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-20
Locating System Defaults Schema Tables
(select schema_uid
from nonstop_sqlmx_figaro.system_schema.schemata
where
schema_name = 'SYSTEM_DEFAULTS_SCHEMA' and
cat_uid =
-- get catalog uid for CAT
(select cat_uid
from nonstop_sqlmx_figaro.system_schema.catsys
where cat_name = 'NONSTOP_SQLMX_FIGARO'
)
)
for read uncommitted access;
TABLE_NAME SYSTEM DATA_SOURCE FILE_SUFFIX
------------------ ------- ----------- -----------------
SYSTEM_DEFAULTS \FIGARO $DATA08 ZSDA984F.FPJCX800
--- 1 row(s) selected.
>> exit;
# ls /G/data08/ZSDA984f
bd2xt800 d96rs800 fpjcx800 hpz9p800 l2jnr800
q956v800 bd2xt801 d96rs801 fpjcx801 hpz9p801
l2jnr801 q956v801
# mxtool info \$data08.zsdA984f.fpjcx800
NonStop SQL/MX MXTOOL Utility 2.0
(c) Copyright 2003 Hewlett-Packard Development Company, LP.
All Rights Reserved.
File Name: \FIGARO.$DATA08.ZSDA984F.FPJCX800
Object Schema Version: 1200
Ansi Name:
NONSTOP_SQLMX_FIGARO.SYSTEM_DEFAULTS_SCHEMA.SYSTEM_DEFAULTS
Ansi NameSpace: TA
•
This example uses the SHOWLABEL command to locate the
SYSTEM_DEFAULTS table; only part of the output is included.
>>showlabel
nonstop_sqlmx_figaro.system_defaults_schema.system_defaults;
=============================================================
GuardianName: \FIGARO.$DATA08.ZSD966LH.J63L2N00
AnsiName:
NONSTOP_SQLMX_FIGARO.SYSTEM_DEFAULTS_SCHEMA.SYSTEM_DEFAULTS
AnsiNameSpace: TA
ObjectSchemaVersion: 1200
ObjectFeatureVersion: 1200
Owner: SUPER.SUPER