Characteristics of SQL statements in DB2 for z/OS®

DB2® allows specific actions on each SQL statement, and only certain SQL statements are allowed in external routines and SQL procedures.

Actions allowed on SQL statements
Specific DB2 statements can be executed, prepared interactively or dynamically, or processed by the requester, the server, or the precompiler or coprocessor.
SQL statement data access classification for routines
Certain SQL statements can be executed in a stored procedure or in a user-defined function. Whether the statements can be executed depends on the level of SQL data access with which the routine is defined.

Parent topic: Additional information for DB2 SQL