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-38
Displaying All Attributes of an SQL/MP Alias Name
Displaying All Attributes of an SQL/MP Alias Name
This example displays some of the attributes for the SQL/MP aliases in the
SAMDBCAT.SALES schema:
>> set schema samdbcat.definition_schema_version_1200;
--- SQL operation complete.
>> select substring(object_name,1,25) as SQLMP_Alias,
m.mppartition_name
from nonstop_sqlmx_figaro.system_schema.catsys c,
nonstop_sqlmx_figaro.system_schema.schemata s,
objects o,
mp_partitions m
where c.cat_uid=s.cat_uid
and c.cat_name='SAMDBCAT'
and s.schema_uid=o.schema_uid
and s.schema_name='SALES'
and o.object_type='MP'
and m.object_uid = o.object_uid
for read uncommitted access;
SQLMP_ALIAS MPPARTITION_NAME
------------------------- ------------------------------------
OLDCUSTS \FIGARO.$DATA08.SQLMP.CUSTS
Displaying Information About SPJs
The ROUTINES table contains information about stored procedures in Java (SPJs). All
queries for information about a specific SPJs must access information from the
CATSYS, SCHEMATA, and OBJECTS tables, and from the ROUTINES table.
For detailed information about all metadata tables, see Table 8-1 on page 8-6 or the
SQL/MX Reference Manual.
For information about displaying all SPJs in a catalog and displaying the syntax of
SPJs, see the SQL/MX Guide to Stored Procedures in Java.
Displaying Index Information
Topics in this subsection:
•
Determining Whether a Table Has Indexes on page 8-39
•
Displaying All Indexes for a Table on page 8-40
•
Displaying All DDL Locks on an Index on page 8-41
•
Displaying the Attributes of an Index on page 8-42
•
Displaying the State of Indexes for a Table on page 8-43