SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
8-56
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_<schema
version>;
--- 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_<sys name>.system_schema.schemata
where
schema_name = 'SALES' and
cat_uid =
(select cat_uid
from nonstop_sqlmx_<sys name>.system_schema.catsys
where cat_name = 'SAMDBCAT'
)
)
for read uncommitted access;
COLUMN_NAME BASE_TABLE_COLUMN SYSTEM_ADDED_COLUMN
----------------------- ----------------- -------------------
CUSTNUM 0 Y
CUSTNAME 1 N