PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5.1
- All Products
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 |