SQL Guide : Database system tables and system views : System tables : SYS_PROCEDURE_COLUMNS
  
SYS_PROCEDURE_COLUMNS
The SYS_PROCEDURE_COLUMNS defines input parameters and result set columns.
Column name
Data type
Description
PROCEDURE_ID
INTEGER
Procedure identifier.
COLUMN_NAME
WVARCHAR
Procedure column name.
COLUMN_TYPE
SMALLINT
Procedure column type (SQL_PARAM_INPUT or SQL_RESULT_COL).
DATA_TYPE
SMALLINT
Column’s SQL data type.
TYPE_NAME
WVARCHAR
Column’s SQL data type name.
COLUMN_SIZE
INTEGER
Size of the procedure column.
BUFFER_LENGTH
INTEGER
Column size in bytes.
DECIMAL_DIGITS
SMALLINT
Decimal digits of the procedure column.
NUM_PREC_RADIX
SMALLINT
Radix for numeric data types (2, 10, or NULL if not applicable).
NULLABLE
SMALLINT
Whether the procedure column accepts a NULL value.
REMARKS
WVARCHAR
A description of the procedure column.
COLUMN_DEF
WVARCHAR
Column’s default value. Always NULL, that is, no default value is specified.
SQL_DATA_TYPE
SMALLINT
SQL data type.
SQL_DATETIME_SUB
SMALLINT
Subtype code for datetime. Always NULL.
CHAR_OCTET_LENGTH
INTEGER
Maximum length in bytes of a character or binary data type column.
ORDINAL_POSITION
INTEGER
Ordinal position of the column.
IS_NULLABLE
WVARCHAR
Always "YES".
See also
System tables