DB2 10.5 for Linux, UNIX, and Windows

EXEC_DDL_STATEMENT procedure - Run a DDL statement

The EXEC_DDL_STATEMENT procedure provides the capability to execute a DDL command.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_UTILITY.EXEC_DDL_STATEMENT--(--parse_string--)---------><

Parameters

parse_string
An input argument of type VARCHAR(1024) that specifies the DDL command to execute.

Authorization

EXECUTE privilege on the DBMS_UTILITY module.

Examples

Example 1: The following anonymous block creates the job table.
BEGIN
  CALL DBMS_UTILITY.EXEC_DDL_STATEMENT(
    'CREATE TABLE job (' ||
    'jobno DECIMAL(3),' ||
    'jname VARCHAR(9))' );
END@