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

check_option, is_updatable, is_insertable
from nonstop_sqlmx_<system name>.system_schema.catsys c,
nonstop_sqlmx_<system name>.system_schema.schemata s,
objects o,
vws v
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 = 'VI'
and v.object_uid = o.object_uid
order by object_name
for read uncommitted access;
IS_INSERTABLE
-------------
IS_UPDATABLE
------------
CHECK_OPTION
------------
OBJECT_NAME
--------------------
Y
N
Y
N
N
N
CUSTLIST
ORDREP
Displaying Information About SQL/MP Aliases
Topics in this subsection:
• “Displaying all SQL/MP Alias Names in a Schema” (page 130)
• “Displaying all Attributes of an SQL/MP Alias Name” (page 130)
The MP_PARTITIONS table contains the partition names of SQL/MP tables that have SQL/MP
aliases. For more information about all metadata tables, see Figure 3 (page 109) in this manual or
the SQL/MX Reference Manual.
All queries for information about a specific SQL/MP alias must access information from these
tables:
• CATSYS table
• SCHEMATA table
• OBJECTS table
• MP_PARTITIONS table
Displaying all SQL/MP Alias Names in a Schema
This example displays all SQL/MP aliases in a given schema:
>> select substring(object_name,1,25) as SQLMP_Alias
from nonstop_sqlmx_<system name>.system_schema.catsys c,
nonstop_sqlmx_<system name>.system_schema.schemata s, objects
o
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';
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,
130 Querying SQL/MX Metadata