|
|
EXECUTE IMMEDIATE
Prepares and executes a dynamically submitted SQL statement.
Usage
Description
The SQL source statement contained in the host variable is prepared and executed.
For a fuller discussion of the use of EXECUTE statements in dynamic application programs, see the Mimer SQL Programmer's Manual.
Restrictions
The EXECUTE IMMEDIATE statement may only be used for dynamically submitted statements with no parameter markers. Dynamically submitted SELECT statements may not be executed with EXECUTE IMMEDIATE, these should be performed using a sequence of OPEN, FETCH and CLOSE statements.
Standard Compliance
Standard
Compliance
Comments
X/Open-95
SQL92 YES Fully compliant.
|
Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|