SCHEMANAME

CHAR(32)

Name of the schema of the database procedure

DBPROCNAME

CHAR(32)

Name of the database procedure

OWNER

CHAR(32)

Name of the owner of the database procedure

PACKAGE

CHAR(32)

Package containing the database procedure

DBPROCID

CHAR(8)

ID of the database procedure in hexadecimal format

PARAMETER

FIXED(4)

Number of parameters for the database procedure

CREATEDATE

DATE

Creation date of the database procedure

CREATETIME

TIME

Creation time of the database procedure

EXECUTION_KIND

CHAR(10)

Execution location of database procedure (INPROC | LOCAL)

LANGUAGE

CHAR(32)

Implementation language of database procedure (SPL | C++ | JAVA | ...)

SQL_SUPPORT

CHAR(3)

Database procedure may contain SQL statements (YES | NO)

CURSOR_SUPPORT

CHAR(3)

The database system returns a cursor (YES | NO)

WAIT_FOR_CHCKPT

CHAR(3)

NULL

REMOTE_LOCATION

CHAR(132)

NULL

DEFINITION

CLOB

SQL statement for defining the database procedure

COMMENT

CLOB

Comment on the database procedure