ALLBASE/SQL Reference Manual (36216-90216)

420 Chapter11
SQL Statements E - R
EXECUTE IMMEDIATE
EXECUTE IMMEDIATE
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.