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

• “Displaying the Object Schema Version (OSV)” (page 148)
• “Displaying the Object Feature Version (OFV)” (page 148)
Displaying the NonStop SQL/MX Release Identifier
To obtain the release number of the SQL/MX software running on a specified node, see the banner
generated by mxci. For SQL/MX Release 3.2, mxci displays the release identifier 3.2.
For example, the mxci banner displays the following information for SQL/MX Release 3.2:
Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 3.2 (c)
Copyright 2003, 2004-2011 Hewlett-Packard Development Company, LP.
Displaying the Schema Version
This example displays the version number of a specified schema:
>> select s.schema_version
from nonstop_sqlmx_node.system_schema.schemata s,
nonstop_sqlmx_node.system_schema.catsys c
where c.cat_name = 'catalog-name'
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” (page 148) 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
148 Querying SQL/MX Metadata