|
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
|
SQL data type of column.
|
|
TYPE_NAME
|
WVARCHAR
|
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 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".
|