DBPROCPARAMS

Definition

The system table DBPROCPARAMS contains all the parameters of a database procedure for which the current user has privileges.

Structure

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)

Name of the parameter

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 column (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(10)

Creation date of the database procedure

CREATETIME

TIME(8)

Creation time of the database procedure

See also:

Evaluating System Tables, DBPROCPARAMS

SQL Reference Manual, Name of a Database Procedure (dbproc_name), Data Type (data_type)