The system table DOMAIN.DBPROCPARAMS contains all the parameters of a database procedure for which the current user has privileges.
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 |
Evaluating System Tables, DBPROCPARAMS
SQL Reference Manual, Name of a Database Procedure (dbproc_name),