Statements that can be dynamically prepared

From SQL PL Guide for DB2

List of statements that can be dynamically prepared

The following SQL statements can be used in DB2 SQL PL stored procedures as dynamic SQL statements:

ALTER
CALL
COMMENT ON
COMMIT
CREATE
DECLARE GLOBAL TEMPORARY TABLE
DELETE
DROP
EXPLAIN
FLUSH EVENT MONITOR
GRANT
INSERT
LOCK TABLE
REFRESH TABLE
RELEASE SAVEPOINT
RENAME TABLE
RENAME TABLESPACE
REVOKE
SAVEPOINT
<select-statement>
SET CURRENT DEFAULT TRANSFORM GROUP
SET CURRENT DEGREE
SET CURRENT EXPLAIN MODE
SET CURRENT EXPLAIN SNAPSHO
SET CURRENT QUERY OPTIMIZATION
SET CURRENT REFRESH AGE
SET EVENT MONITOR STATE
SET INTEGRITY
SET PASSTHRU
SET PATH
SET SCHEMA
SET SERVER OPTION
UPDATE