Description

variable
Identifies a variable that must be declared in accordance with the rules for declaring character-string or Unicode graphic variables. An indicator variable must not be specified.
string-expression
A string-expression is any PL/I string-expression that yields a character string. SQL expressions that yield a character string are not allowed. A string-expression is only allowed in PL/I.

The value of the identified variable or string expression is called a statement string.

The statement string must be one of the following SQL statements:70

ALTER INSERT SET CURRENT DEBUG MODE
CALL LABEL SET CURRENT DEGREE
COMMENT LOCK TABLE SET ENCRYPTION PASSWORD
COMMIT REFRESH TABLE SET PATH
CREATE RELEASE SAVEPOINT SET SCHEMA
DECLARE GLOBAL TEMPORARY TABLE RENAME SET SESSION AUTHORIZATION
DELETE REVOKE SET TRANSACTION
DROP ROLLBACK UPDATE
GRANT SAVEPOINT

The statement string must not:

When an EXECUTE IMMEDIATE statement is executed, the specified statement string is parsed and checked for errors. If the SQL statement is not valid, it is not executed and the error condition that prevents its execution is reported in the stand-alone SQLSTATE and SQLCODE. If the SQL statement is valid, but an error occurs during its execution, that error condition is reported in the stand-alone SQLSTATE and SQLCODE. Additional information on the error can be retrieved from the SQL Diagnostics Area (or the SQLCA).


70.
A select-statement is not allowed. To dynamically process a select-statement, use the PREPARE, DECLARE CURSOR, and OPEN statements.