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).
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.