OWNER

CHAR(32)

Name of the owner of the database procedure

DBPROCNAME

CHAR(32)

Name of the database procedure

PACKAGE

CHAR(32)

Package containing the database procedure

PARAMETER

FIXED(4)

Number of parameters for the database procedure

CREATEDATE

DATE(10)

Creation date of the database procedure

CREATETIME

TIME(8)

Creation time of the database procedure

EXCECUTION_KIND

CHAR(6)

Execution location of the database procedure (INPROC / LOCAL / REMOTE)

SQL_SUPPORT

CHAR(3)

Database procedure may contain SQL statements (YES / NO)

WAIT_FOR_CHCKPT

CHAR(3)

Database procedure waits for a checkpoint (NO / YES)

REMOTE_LOCATION

CHAR(132)

Execution location

DEFINITION

LONG

SQL statement for defining the database procedure

COMMENT

LONG

Comment on the database procedure