Reference Manual

Back Next

DTLDESCRIBE PROCEDURECOLUMNS Returned Information

The following table describes the columns:

Column Name	Description
PROCEDURE_CAT	Procedure catalog, null if not present; VARCHAR
PROCEDURE_SCHEM	Procedure schema, null if not present; VARCHAR
PROCEDURE_NAME	Procedure name; VARCHAR
COLUMN_NAME	Column name; VARCHAR
COLUMN_TYPE	Column type, not null; SMALLINT Can be 0 - SQL_PARAM_TYPE_UNKNOWN 1 - SQL_PARAM_INPUT - input parameter 2 - SQL_PARAM_INPUT_OUTPUT - input/output parameter 3 - SQL_RESULT_COLUMN - Parm is a column inset 4 - SQL_PARAM_OUTPUT - output parameter 5 - SQL_RETURN_VALUE - Column is return value of procedure
DATA_TYPE	SQL datatype, not null; SMALLINT
TYPE_NAME	Type name, character string representing datatype, not null; VARCHAR
COLUMN_SIZE	Column size; INTEGER
BUFFER_LENGTH	Buffer length. Maximum number of bytes required to store column data; INTEGER
DECIMAL_DIGITS	Scale, NULL if not applicable; SMALLINT
NUM_PREC_RADIX	Precision; SMALLINT
NULLABLE	Nullable, not null, determines if column will accept a null value; SMALLINT. Can be 0 - SQL_NO_NULLS 1 - SQL_NULLABLE
REMARKS	Remarks; VARCHAR
COLUMN_DEF	Column default value; VARCHAR
SQL_DATA_TYPE	SQL Datatype, not null; SMALLINT
SQL_DATETIME_SUB	Datetime subtype. Can be 1 - SQL_CODE_DATE 2 - SQL_CODE_TIME 3 - SQL_CODE_TIMESTAMP
CHAR_OCTET_LENGTH	Maximum length in bytes of a character type column; INTEGER
ORDINAL_POSITION	Ordinal Position if parameter given by Column name in result set, not null; INTEGER
IS_NULLABLE	Can the column contain nulls. “YES” if column can contain nulls, “NO” if not; VARCHAR