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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-12
ACCESS_PATH_COLS Table
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:
15 LOCK_LENGTH INT Reserved for future use
16 AUDITED CHAR(2) Y if this path is audited
N if not
17 AUDIT_COMPRESS CHAR(2) Y if audit is compressed
N if not
18 CLEAR_ON_PURGE CHAR(2) Y if deleted records are cleared
N if not
19 BUFFERED CHAR(2) Reserved for future use
20 RECORD_PACKED CHAR(2) Reserved for future use
21 DATA_COMPRESSED CHAR(2) Reserved for future use
22 INDEX_COMPRESSED CHAR(2) Reserved for future use
23 PACKING_SCHEME INT Reserved for future use
24 PACKING_FACTOR INT Reserved for future use
25 ALL_COLUMNS_INCLUDED CHAR(2) Y if all columns included
N if not
* 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