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-68
Displaying the Object Feature Version (OFV)
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';