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-13
Managing SQL/MX Database Object Versions
Default Compiler Version
Each SQL/MX release has a default version of the SQL/MX compiler. The default
compiler is the first SQL/MX compiler that NonStop SQL/MX uses to compile a query
execution plan. The default compiler version corresponds to the plan version that the
compiler produces.
Plan Versions
The query execution plan of an SQL statement is assigned a plan version depending
on the SQL/MX release that is installed on the node where the plan is compiled. For
details, see Query Plan Versioning in SQL/MX Releases 2.x
on page 2-14.
NonStop SQL/MX successfully compiles and executes a query execution plan if the
plan version is higher than or equal to the earliest supported plan version and lower
than or equal to the current plan version of the node where the plan is being executed.
Otherwise, NonStop SQL/MX returns a versioning error.
Module Versions
When you compile user modules of embedded SQL/MX applications, the version
assigned to a module is the same as the default compiler version of the node where
you compile the module. The default compiler version of a node is equal to the MXV of
the node. The SQL/MX compilers produce the following module versions:
For a user module to be executed on a node, the module version must be higher than
or equal to the earliest supported plan version and lower than or equal to the current
plan version. Otherwise, NonStop SQL/MX returns a versioning error.
Managing SQL/MX Database Object Versions
For SQL/MX Release 2.x, all SQL/MX database objects have a version of 1200.
Therefore, there are no management considerations.
SQL/MX Compiler User Module Version
SQL/MX Release 2.3.4 compiler 2400
SQL/MX Release 2.3.3 compiler 2200
SQL/MX Release 2.3.2 compiler 2000
SQL/MX Release 2.3.1 compiler 1800
SQL/MX Release 2.3 compiler 1600
SQL/MX Release 2.2 compiler 1600
SQL/MX Release 2.1 compiler 1400
SQL/MX Release 2.0 compiler 1200
SQL/MX Release 1.8 compiler 800