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-25
Displaying the Attributes of a Catalog
MVS00000 MVS00001 MVSCOL00 MVSCOL01 MVSJCL00 MVSJCL01
MVSTIN00 MVSTIN01 MVSUSE00 MVSUSE01 OBJECT00 OBJECT01
PARTNS00 PARTNS01 REFCON00 REFCON01 REPLIC00 REPLIC01
RIUU0000 RIUU0001 ROUTIN00 ROUTIN01 TBLCON00 TBLCON01
TBLPRI00 TBLPRI01 TBLTEX00 TBLTEX01 TRGCU000 TRGCU001
TRGUSD00 TRGUSD01 TRIGS000 TRIGS001 VCOLTA00 VCOLTA01
VCOLTC00 VCOLTC01 VCOLU000 VCOLU001 VIEWS000 VIEWS001
VWTBLU00 VWTBLU01
Displaying the Attributes of a Catalog
This example is a combination of the previous examples. It displays all catalog
attributes:
>> set schema nonstop_sqlmx_figaro.system_schema;
--- SQL operation complete.
>> select
substring(c.cat_name,1,10) as name,
case c.replication_rule
when 'A' then 'AUTOMATIC'
when 'M' then 'MANUAL'
else 'UNKNOWN'
end as rep_rule,
c.local_smd_volume as smd_vol,
c.local_user_schema_count as schema_cnt,
c.cat_owner as owner
from catsys c
where c.cat_name = 'SAMDBCAT'
for read uncommitted access;
NAME REP_RULE SMD_VOL SCHEMA_CNT OWNER
---------- --------- -------- ----------- -----------
SAMDBCAT AUTOMATIC $DATA08 0 65535
Displaying Schema Information
This subsection discusses:
•
Displaying a Schema UID on page 8-26
•
Displaying All Schemas Visible on a Node on page 8-27
•
Displaying All Objects in a Schema on page 8-28
•
Displaying the Attributes of a Schema on page 8-29
•
Displaying the Owner of a Schema on page 8-29
Related topics:
•
Locating System Schema Tables on page 8-15
•
Locating System Defaults Schema Tables on page 8-18