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-63
Displaying the System Schema Version
and c.cat_uid = s.cat_uid
and s.schema_name = 'schema-name';
Displaying the System Schema Version
This example displays the version number of the system schema:
>> select s.schema_version
from nonstop_sqlmx_node.system_schema.schemata s,
nonstop_sqlmx_node.system_schema.catsys c
where c.cat_name = 'NONSTOP_SQLMX_node'
and c.cat_uid = s.cat_uid
and s.schema_name = 'SYSTEM_SCHEMA';
Displaying the Object Schema Version (OSV)
The example in Displaying the System Schema Version also applies to the OSV.
The MXCI SHOWLABEL command also displays object schema and object feature
version information.
Displaying the Object Feature Version (OFV)
This example displays the object feature version (OFV) of a specified database object:
>> select o.object_feature_version
from nonstop_sqlmx_node.system_schema.schemata s,
nonstop_sqlmx_node.system_schema.catsys c,
catalog-name.definition_schema_version_schema-version.objects o
where c.cat_name = 'catalog-name'
and c.cat_uid = s.cat_uid
and s.schema_name = 'schema-name'
and s.schema_uid = o.schema_uid
and o.object_name = 'object-name';
This example is the same as the previous but limits the query to a specified name
space:
>> select o.object_feature_version
from nonstop_sqlmx_node.system_schema.schemata s,
nonstop_sqlmx_node.system_schema.catsys c,
catalog-name.definition_schema_version_schema-version.objects o
where c.cat_name = 'catalog-name'
and c.cat_uid = s.cat_uid
and s.schema_name = 'schema-name'
and s.schema_uid = o.schema_uid
and o.object_name = 'object-name'
and o.object_name_space = 'name-space';