SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-14
ACCESS_PATH_COLS Table
In version 1200 schemas, the primary key consists of the ACCESS_PATH_UID
column. In version 3000 and higher version 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:
27 INSERT_MODE CHAR(2) Reserved for future use
28 MAX_TABLE_SIZE INT Reserved for future use
29 RESERVED_FILLER_INT INT Reserved for future use
30 RESERVED_FILLER_CHAR CHAR(20) Reserved for future use
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