Object documentationDBPROCPARAMS Locate this document in the navigation structure

 

The system table DOMAIN.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)

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

More Information

Evaluating System Tables, DBPROCPARAMS

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

Data Type (data_type)