SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-13
CK_COL_USAGE Table
CK_COL_USAGE Table
CK_COL_USAGE is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that lists columns referenced by search conditions of check constraints in the catalog.
CK_TBL_USAGE Table
CK_TBL_USAGE is a metadata table in DEFINITION_SCHEMA that lists tables
referenced by search conditions of check constraints in the catalog.
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 CONSTRAINT_UID LARGEINT UID of constraint
*2 TABLE_UID LARGEINT UID of table with referenced column
*3 COLUMN_NUMBER INT Column position in table (first column is 0)
4 SELECTS CHAR(2) Y if column is subject of a SELECT query in
constraint definition
N if not
* Indicates primary key
Column Name Data Type Description
*1 CONSTRAINT_UID LARGEINT UID of constraint
*2 TABLE_UID LARGEINT UID of table with referenced column
* Indicates primary key
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
* Indicates primary key