SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-14
COLS Table
In SQL/MX Release 2.0, you can reference only one table in a search condition.
COLS Table
COLS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that
describes columns in tables and views in the catalog. The COLS table also contains
attributes of the individual parameters of an SPJ, one row per parameter.
Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID of table, view or stored
procedure
*2 COLUMN_NUMBER INT Logical position within row (first
column is 0)
3 DIRECTION CHAR(2) I if input parameter to stored
procedure
O if OUTPUT parameter to stored
procedure
N if INPUT/OUTPUT parameter to
stored procedure
4 COLUMN_CLASS CHAR(2) S if system-defined
U if user-defined
A if user-defined added column
5 COLUMN_NAME CHAR(128) Column name
6 COLUMN_SIZE LARGEINT Data bytes in column
7 SQL_DATA_TYPE CHAR(18) One of these SQL data types:
CHARACTER
DATE
DATETIME
SIGNED DECIMAL
UNSIGNED DECIMAL
DOUBLE
FLOAT
SIGNED INTEGER
INTERVAL
UNSIGNED BP INT
UNSIGNED INTEGER
SIGNED LARGEINT
SIGNED NUMERIC
UNSIGNED NUMERIC
REAL
SIGNED SMALLINT
UNSIGNED SMALLINT
TIME
TIMESTAMP
VARCHAR
LONG VARCHAR
8 CHARACTER_SET CHAR(40) Character set