|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The different syntaxes for declaring a procedure... |
|
|
|
|
|
|
|
| A global procedure can be used in all the processes or events of the project. |
|
|
|
|
|
|
|
| You have the ability to pass parameters to a procedure. |
|
|
|
|
|
|
|
| The parameters can be passed to a procedure... |
|
|
|
|
|
|
|
| When the procedure uses a variable number of parameters, you must be able to handle the different parameters passed to the function in the code of the procedure. |
|
|
|
|
|
|
|
| The description of the parameter type is optional... |
|
|
|
|
|
|
|
| Two types of procedures are available... |
|
|
|
|
|
|
|
| Changes the DNS name of the replication server if it has a new name. |
|
|
|
|
|
|
|
| Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string. |
|
|
|
|
|
|
|
| Converts a DateTime to string in the specified format. |
|
|
|
|
|
|
|
| Checks the validity of a Canadian 15-digit Business Number (BN15). |
|
|
|
|
|
|
|
| Checks the validity of a Canadian 9-digit Business Number (BN9). |
|
|
|
|
|
|
|
| Indicates the presence of a shape at a given position in the Diagram Editor control. |
|
|
|
|
|
|
|
| Returns the list of recipients for a notification by email. |
|
|
|
|
|
|
|
| Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
|
| Deletes the recipients of an email notification. |
|
|
|
|
|
|
|
| Returns the list of automatic operations in progress on an HFSQL server. |
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| Finds out and modifies the priority of the calling application. |
|
|
|
|
|
|
|
| Modifies the priority of a client application. |
|
|
|
|
|
|
|
| Returns the quality level of connection: the higher the level is, the faster the connection will be. |
|
|
|
|
|
|
|
| Asks to recalculate the content of a materialized view. |
|
|
|
|
|
|
|
| Creates a text file containing the server logs between two given dates. |
|
|
|
|
|
|
|
| Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server. |
|
|
|
|
|
|
|
| Used to restore:
an immediate backup (performed by HBackup or via the HFSQL Control Center),... |
|
|
|
|
|
|
|
| Adds a replication between two HFSQL server onto the master server. |
|
|
|
|
|
|
|
| Waits for:
the replication data on the master server to be sent to the subscriber server.... |
|
|
|
|
|
|
|
| Immediately runs a recurring replication between HFSQL servers: the replication is triggered... |
|
|
|
|
|
|
|
| Reads the replication configuration for an HFSQL server that takes part in one... |
|
|
|
|
|
|
|
| Configures an HFSQL server in order for this server to be a master server or a subscriber server... |
|
|
|
|
|
|
|
| Lists the replications available on a master HFSQL server. |
|
|
|
|
|
|
|
| Modifies some parameters of an existing replication between two HFSQL servers. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|