SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-15
CK_TBL_USAGE Table
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.
*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
5 COLUMN_NAME CHAR(128) Column name
6 COLUMN_SIZE LARGEINT Data bytes in column
Column Name Data Type Description