The EXECUTE IMMEDIATE statement dynamically prepares and executes an SQL statement.
Scope |
|
ISQL or Application Programs
SQL Syntax |
|
EXECUTE IMMEDIATE {'String'
:HostVariable} |
Parameters |
|
- String
is the ALLBASE/SQL statement to be executed.
- HostVariable
identifies a character-string host variable containing
the ALLBASE/SQL statement to be executed.
Description |
|
When used interactively,
a host variable cannot be specified.
The SQL statement cannot contain host variables
nor dynamic parameters.
You cannot use the EXECUTE IMMEDIATE statement for any of the following statements:
BEGIN DECLARE SECTION EXECUTE SELECT
CLOSE EXECUTE IMMEDIATE SQLEXPLAIN
DECLARE CURSOR FETCH UPDATE WHERE CURRENT
DELETE WHERE CURRENT INCLUDE WHENEVER
DESCRIBE OPEN
END DECLARE SECTION PREPARE
Authorization |
|
You can use EXECUTE IMMEDIATE if your authorization permits you to issue the statement to
be executed.
Example |
|
If you know that the statement to be dynamically preprocessed
is neither a SELECT statement nor an EXECUTE PROCEDURE statement with results, and has neither input nor output
dynamic parameters, you can prepare it and execute it in one step.
EXECUTE IMMEDIATE :Dynam1
|
In other instances, it is more appropriate to prepare and
execute the statement in separate operations.