|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Used to find out and modify some settings of HFSQL Client/Server server.... |
|
|
|
|
|
|
|
| Enables or disables a scheduled task on an HFSQL Client/Server server.... |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on a database. |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on an HFSQL Client/Server data... |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or group of users on a server. |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on an SQL view... |
|
|
|
|
|
|
|
| Denies all new connections to a database or to all databases. |
|
|
|
|
|
|
|
| Lists the Client/Server databases associated with a connection.... |
|
|
|
|
|
|
|
| Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures... |
|
|
|
|
|
|
|
| Returns the list of groups of users defined for a connection. |
|
|
|
|
|
|
|
| Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.... |
|
|
|
|
|
|
|
| Returns the list of parameters saved from the stored procedures on the server. |
|
|
|
|
|
|
|
| Lists the scheduled tasks defined on an HFSQL server:
stored procedure,
backup,... |
|
|
|
|
|
|
|
| Lists the full and differential backups that have been scheduled on HFSQL Client/Server.... |
|
|
|
|
|
|
|
| Lists the scheduled tasks of an HFSQL Client/Server server for a given connection.... |
|
|
|
|
|
|
|
| Returns the list of users defined for a connection. |
|
|
|
|
|
|
|
| Checks and optimizes the system tables of an HFSQL server. |
|
|
|
|
|
|
|
| Creates or updates a set of procedures on an HFSQL server. |
|
|
|
|
|
|
|
| Creates or updates a query on an HFSQL server. |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis... |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or to a group for a HFSQL Client/Server database.... |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or group on an HFSQL Client/Server data file.... |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or to a group on a HFSQL server. |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server data file.... |
|
|
|
|
|
|
|
| Returns information about the specified group of users. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|