SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
8-67
Displaying the NonStop SQL/MX Release Identifier
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.1, mxci displays the
release identifier
3.1.
For example, the
mxci banner displays the following information for SQL/MX Release
3.1:
Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 3.1
(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 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'