MX Database and Application Migration Guide

Version Management and Interoperability

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001

2-9

SQL/MX Database Object Versions

Schema Version and Object Schema Version

A schema version is assigned to each user schema at creation time and is based on

the version of the SQL/MX compiler that creates the schema. The Object Schema

Version (OSV) of a SQL/MX database object is inherited from the schema where the

object resides and determines whether the object can be accessed by a particular

version of NonStop SQL/MX or not.

NonStop SQL/MX uses the earliest supported schema version of the node to

determine if it can access a SQL/MX database object in a schema that has a lower

version. If the object’s OSV is higher than or equal to the earliest supported schema

version and lower than or equal to the MXV (which is often the same as the current

schema version) of the node, NonStop SQL/MX accesses the object. Otherwise,

NonStop SQL/MX returns a versioning error.

For SQL/MX Release 3.0, the schema version is 3000. For earlier releases of SQL/MX,

the schema version is 1200.

A database object can be accessed if all involved systems and schemas are version

compatible.

Displaying the OSV

This example displays the OSV of a specified schema, where sch is the schema

name:

>>get version of schema sch;

VERSION: 3000

--- SQL operation complete.

For more information, see the SQL/MX Reference Manual.

Object Feature Version

The OFV of a 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.