SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Version Management and Interoperability
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
2-12
SQL/MX Query Plan and Module Versions
The catalog and schema names must be in internal format. For more information,
see the
SQL/MX Reference Manual.
Object Feature Version (OFV)
The OFV of an SQL/MX database object represents the lowest version schema that
can accommodate the features used by that object. The OFV is computed from the
actual features used by a database object, not from the version of the software that
creates the database object.
For SQL/MX Release 2.x, all SQL/MX database objects have an OSV and OFV of
1200 and are accessible from SQL/MX Release 2.0, SQL/MX Release 2.1, and
SQL/MX Release 2.2 nodes, regardless of where the objects reside in the network.
Displaying the OFV
This example displays the object feature version (OFV) of a specified database object,
limiting the query to a specified name space, where
node, catalog, schema-
version, schema, object, and name-space are values that you specify:
select o.object_feature_version
from nonstop_sqlmx_node.system_schema.schemata s,
nonstop_sqlmx_node.system_schema.catsys c,
catalog.definition_schema_version_schema-version.objects o
where c.cat_name = 'catalog'
and c.cat_uid = s.cat_uid
and s.schema_name = 'schema'
and s.schema_uid = o.schema_uid
and o.object_name = 'object'
and o.object_name_space = 'name-space';
OBJECT_FEATURE_VERSION
----------------------
1200
--- 1 row(s) selected.
The catalog and schema names must be in internal format. For more information,
see the
SQL/MX Reference Manual.
The MXCI SHOWLABEL command also displays object schema and object feature
version information.
SQL/MX Query Plan and Module Versions
Query plan versioning is a set of mechanisms that allow SQL/MX software to assign a
version to query execution plans and user modules and to determine if the version of a
query execution plan or module is compatible with the MXV. Query plan versions
include the plan version and module version.