DBPROCPARAMS

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

PARAMETERNAME

CHAR(32)

Parameter name

POS

FIXED(4)

Original position of the parameter in the database procedure

IN/OUT TYPE

CHAR(6)

Type of parameter (IN | OUT)

DATATYPE

CHAR(10)

Data type of the parameter (BOOLEAN | CHAR | DATE | FIXED | FLOAT | TIME | TIMESTAMP)

CODETYPE

CHAR(8)

Code attribute of the parameter (ASCII | BYTE | UNICODE)

LEN

FIXED(4)

Length or precision of the parameter

DEC

FIXED(3)

Number of decimal places of the parameter with data type FIXED

CREATEDATE

DATE

Creation date of the database procedure

CREATETIME

TIME

Creation time of the database procedure