SQL/MP Version Management Guide

Version Compatibility for SQL Programs
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
7-8
Reverting to an Older Version
•
The SQL compiler version must be the same as or newer than the newest host object
SQL version in the host object file. SQL compilation fails if the SQL compiler
version is older than the host object SQL version.
•
An SQL compiler running on one node of a network cannot compile host object files
of any version on another node of the network.
•
An existing SQL program moved to another node of a network must be
SQL-compiled again on the node where it is to execute.
Remember that SQL compilation of programs can be affected when the version of a
program is either raised to a newer version or lowered to an older version.
Reverting to an Older Version
The version of an SQL compiler is always the same as the version of the SQL/MP
software running on the same node. If the version of the software running on a node is
downgraded to an older version, the version of the SQL compiler on that node also
reverts to the older version, and it can no longer compile any host object file with a
newer host object SQL version.
The version of a host object SQL file is determined by the SQL version of the host
language compiler that compiles the source file. The version of a host object SQL file
can be the result of binding together several host object SQL files with different
versions.
For example, suppose there are two programs, PROG1 and PROG2. Suppose that
PROG1 is host-compiled on a host language compiler whose SQL version is 2 and that
PROG2 is host-compiled on a host language compiler whose SQL version is 310. If
these two programs are bound together to form a single host object SQL file named
PROGX, the host object SQL version of PROGX is 310.
If you try to compile a host object file whose host object SQL version (HOSV) is 310
with a version 2 or older version SQL compiler, the compilation attempt fails. This type
of failure is illustrated in Figure 7-1
.