The Parms function specifies substitutional parameters to be used in the subsequent SQL statement.
This function is used internally by AQT to load LOB values. Within the Update/Insert Row window, if you specify Load from File for a LOB, you can click on Preview SQL to see how this is used.
If you wish to run a stored procedure in batch mode, you should do this by coding a Parms statement for each procedure parameter. An example of this is given below.
The Parms function takes the following parameters:
The value can be set to the result of a previous query, to an environment variable or to the current date/time. Full details of how to specify these are given in Setparm.
Multiple parameter / value pairs can be specified on a Parms statement.
Examples:
Basic |
|
Two parameters |
|
Inserting a Blob |
|
Running a Stored Procedure |
|
You can generate the SQL (and control statements) for running a stored procedure by clicking on the Copy to SQL Window button from the Run Procedure window.
You can also use queryparm and setparm to specify parameters which are used through the entire script. These functions can do much of what the Parms function does, however you must use Parms if you are doing a BLOB Insert or running a stored procedure.
This is the data type of the parameter. This is discussed in more detail in Running a Stored Procedure. It is recommended that you do not code this directly yourself, but generate this from the Copy to SQL Window button of the Run Procedure window.
You can set a parameter to a value returned by a query, or to an OUT parameter from a stored procedure. This is discussed in more detail in the section on setparm.