SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-52
Displaying All Columns in an Index
Displaying All Columns in an Index
This example displays all columns in the index SAMDBCAT.SALES.XCUSTNAM in the
schema SAMDBCAT.SALES:
>> set schema samdbcat.definition_schema_version_1200;
--- SQL operation complete.
>> select substring(c.column_name, 1, 25) as column_name,
c.column_number as base_table_column,
ac.system_added_column
from access_paths ap, access_path_cols ac, cols c, objects o
where
ap.access_path_uid = o.object_uid
and ap.access_path_uid <> ap.table_uid
and c.object_uid = ap.table_uid
and o.object_name = 'XCUSTNAM'
and ac.column_number = c.column_number
and ac.access_path_uid = ap.access_path_uid
and o.schema_uid =
(select schema_uid
from nonstop_sqlmx_figaro.system_schema.schemata
where
schema_name = 'SALES' and
cat_uid =
(select cat_uid
from nonstop_sqlmx_figaro.system_schema.catsys
where cat_name = 'SAMDBCAT'
)
)
for read uncommitted access;
COLUMN_NAME BASE_TABLE_COLUMN SYSTEM_ADDED_COLUMN
----------------------- ----------------- -------------------
CUSTNAME 1 N
CUSTNUM 0 Y