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-42
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_<schema
version>;
--- SQL operation complete.
>> select substring(object_name,1,25) as SQLMP_Alias,
m.mppartition_name
from nonstop_sqlmx_<system name>.system_schema.catsys c,
nonstop_sqlmx_<system name>.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 \DMR15.$DATA04.SQLMP.CUST
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 Figure 8-2
on page 8-7 in this
manual 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-43

Displaying All Indexes for a Table on page 8-44

Displaying All DDL Locks on an Index on page 8-45

Displaying the Attributes of an Index on page 8-46

Displaying the State of Indexes for a Table on page 8-47