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

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-14
ACCESS_PATH_COLS Table
In version 1200 schemas, the primary key consists of the ACCESS_PATH_UID
column. In version 3000 schemas, the primary key consists of the columns in the
following order:
1. TABLE_UID
2. ACCESS_PATH_UID
ACCESS_PATH_COLS Table
ACCESS_PATH_COLS is a metadata table in
DEFINITION_SCHEMA_VERSION_vernum that describes columns within each
access paths for the catalog:
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.
31 DISK_POOL INT Reserved for future use
32 NUM_DISK_POOL INT Reserved for future use
* Indicates primary key
Column Name Data Type Description
*1 ACCESS_PATH_UID LARGEINT UID of access path
*2 POSITION_IN_ROW INT Ordinal of column within access path
(first position is 0)
3 COLUMN_NUMBER INT Position within row of base table
(first column is 0)
4 ORDERING CHAR(2) A if ascending order
D if descending order
5 PART_KEY_SEQ_NUM INT Order in partitioning key (0 if not in
key)
6 CLUSTERING_KEY_SEQ_NUM INT Order in clustering key (0 if not in
key)
7 SYSTEM_ADDED_COLUMN CHAR(2) Y if system added the column
N if user added the column
* 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
Column Name Data Type Description