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".