Syntax
EXECUTE { SQLString | PreparedStatementIdentifier }
[ USING { String | Identifier } ]
The Execute command can be used in either of the following
ways:
To execute either flavor of statement when that statement contains dynamic
parameters, specify the values in the Using portion of the
command. In this style, the SQLString or previously prepared
PreparedStatementIdentifier is executed using the values supplied as
String or Identifier. The Identifier in the
Using clause must have a result set as its result. Each row of
the result set is applied to the input parameters of the statement to be
executed, so the number of columns in the Using clause's result
set must match the number of input parameters in the Execute
command's SQL statement. The results of each execution of the
Execute command's SQL statement are displayed as they are made.
If the Using clause's result set contains no rows, the
Execute command's SQL statement is not executed.
When auto-commit mode is on, the Using clause's result set
is closed upon the first execution of the Execute command's SQL
statement. To ensure multiple-row execution of the Execute
command, use the
Autocommit command
to turn auto-commit off.