SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

and s.schema_uid = o.schema_uid
and s.schema_name = 'SALES'
order by object_name
for read uncommitted access;
SEC_CLASS
----------
TYPE
----
NAME_SPACE
----------
OBJECT_NAME
-------------------------
User Table
User Table
VI
BT
TA
TA
CUSTLIST
CUSTOMER
User TableNNCNCUSTOMER_412443172_5188
User TablePKCNCUSTOMER_817253172_5188
User TableCCCNDATE_CONSTRNT
OTHERBTTAHISTOGRAMS
OTHERPKCNHISTOGRAMS_249558842_5188
OTHERNNCNHISTOGRAMS_948848842_5188
OTHERBTTAHISTOGRAMS_FREQ_VALS
OTHERPKCNHISTOGRAMS_FREQ_VALS_3649
OTHERNNCNHISTOGRAMS_FREQ_VALS_8547
OTHERBTTAHISTOGRAM_INTERVALS
OTHERNNCNHISTOGRAM_INTERVALS_62116
OTHERPKCNHISTOGRAM_INTERVALS_83646
OTHERBTTAMVS_TABLE_INFO_UMD
OTHERNNCNMVS_TABLE_INFO_UMD_231635
OTHERPKCNMVS_TABLE_INFO_UMD_782835
OTHERBTTAMVS_UMD
OTHERNNCNMVS_UMD_326725152_5188
OTHERPKCNMVS_UMD_462235152_5188
OTHERBTTAMVS_USED_UMD
OTHERNNCNMVS_USED_UMD_251445152_51
OTHERPKCNMVS_USED_UMD_343845152_51
User TableBTTAODETAIL
User TablePKCNODETAIL_545675672_5188
User TableNNCNODETAIL_793765672_5188
User TableBTTAORDERS
User TableNNCNORDERS_347711272_5188
User TablePKCNORDERS_917521272_5188
User TableVITAORDREP
User TableBTTAPARTS
User TableNNCNPARTS_386351772_5188
User TablePKCNPARTS_836161772_5188
User TableIXIXXCUSTNAM
User TableIXIXXORDCUS
User Table
User Table
IX
IX
IX
IX
XORDREP
XPARTDES
Displaying the Attributes of a Schema
This example displays most of the attributes (in other words, SCHEMA_OWNER,
SCHEMA_VERSION, SCHEMA_SUBVOLUME, and others) for the schema SAMDBCAT. SALES:
>> set schema nonstop_sqlmx_<system name>.system_schema;
--- SQL operation complete.
>> select
substring(s.schema_name, 1, 15) as name,
s.schema_owner as owner,
s.schema_version as version,
s.schema_subvolume as subvol,
case s.current_operation
when ' ' then 'NONE'
when 'UG' then 'UPGRADE'
when 'DG' then 'DOWNGRADE'
when 'RP' then 'REPLICATE'
when 'UR' then 'UNREPLICATE'
else 'UNKNOWN'
end as CUR_OP
from schemata s
where
Displaying Schema Information 123