SQL/MX 2.3.x to SQL/MX 3.0 Database and Application Migration Guide (H06.22+, J06.11+)

Version Management and Interoperability
HP NonStop SQL/MX 2.3.x to SQL/MX 3.0 Database and Application Migration Guide—666210-002
3-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 if the object can be accessed by a particular version of
NonStop SQL/MX.
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
The following 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 SQL/MX Language Elements in the SQL/MX Reference
Manual.
Object Feature Version
The Object Feature Version (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 and not from the version
of the software that creates the database object.