DBMS SQL

From SQL PL Guide for DB2

DBMS_SQL module

Module for executing dynamic SQL including DML and DDL.

Routines in the DBMS_SQL module:
- BIND_VARIABLE_BLOB procedure
- BIND_VARIABLE_CHAR procedure
- BIND_VARIABLE_CLOB procedure
- BIND_VARIABLE_DATE procedure
- BIND_VARIABLE_DOUBLE procedure
- BIND_VARIABLE_INT procedure
- BIND_VARIABLE_NUMBER procedure
- BIND_VARIABLE_RAW procedure
- BIND_VARIABLE_TIMESTAMP procedure
- BIND_VARIABLE_VARCHAR procedure
- CLOSE_CURSOR procedure
- COLUMN_VALUE_BLOB procedure
- COLUMN_VALUE_CHAR procedure
- COLUMN_VALUE_CLOB procedure
- COLUMN_VALUE_DATE procedure
- COLUMN_VALUE_DOUBLE procedure
- COLUMN_VALUE_INT procedure
- COLUMN_VALUE_LONG procedure
- COLUMN_VALUE_NUMBER procedure
- COLUMN_VALUE_RAW procedure
- COLUMN_VALUE_TIMESTAMP procedure
- COLUMN_VALUE_VARCHAR procedure
- DEFINE_COLUMN_BLOB procedure
- DEFINE_COLUMN_CHAR procedure
- DEFINE_COLUMN_CLOB procedure
- DEFINE_COLUMN_DATE procedure
- DEFINE_COLUMN_DOUBLE procedure
- DEFINE_COLUMN_INT procedure
- DEFINE_COLUMN_LONG procedure
- DEFINE_COLUMN_NUMBER procedure
- DEFINE_COLUMN_RAW procedure
- DEFINE_COLUMN_TIMESTAMP
- DEFINE_COLUMN_VARCHAR procedure
- DESCRIBE_COLUMNS procedure
- DESCRIBE_COLUMNS2 procedure
- EXECUTE procedure
- EXECUTE_AND_FETCH procedure
- FETCH_ROWS procedure
- IS_OPEN procedure
- LAST_ROW_COUNT procedure
- OPEN_CURSOR procedure
- PARSE procedure
- VARIABLE_VALUE_BLOB procedure
- VARIABLE_VALUE_CHAR procedure
- VARIABLE_VALUE_CLOB procedure
- VARIABLE_VALUE_DATE procedure
- VARIABLE_VALUE_DOUBLE procedure
- VARIABLE_VALUE_INT procedure
- VARIABLE_VALUE_NUMBER procedure
- VARIABLE_VALUE_RAW procedure
- VARIABLE_VALUE_TIMESTAMP procedure
- VARIABLE_VALUE_VARCHAR procedure

---

Link to the DB2 Information Center: DB2 9.7