SQL/MP Version Management Guide

Version Compatibility for SQL Programs
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
7-9
Reverting to an Older Release
When SQL/MP software is downgraded to an older version, you must take special steps
to SQL-compile host object files whose host language compiler SQL version is newer
than the SQL/MP software. Specifically, you must either reinstall the newer version
SQL/MP software or perform these steps:
1. Remove any source code from the program that uses newer version features.
2. Host-recompile the source file on a host language compiler whose SQL version
matches the version of the SQL/MP software. In this way, you can produce a host
object file whose SQL version is the same as the version of the software.
3. SQL-recompile the host object file by using an SQL compiler whose version
matches the version of the SQL/MP software. In this way, you can produce an
executable SQL program whose format version matches the version of the SQL/MP
software.
For more information on SQL program versions, see Section 5, Program Versions
.
Reverting to an Older Release
If the operating-system release of the host language compiler is newer than the
operating-system release of the SQL compiler, SQL compilation fails. For example, if
you attempt to use a C-series version 2 SQL compiler to compile a program that was
host-compiled by a D-series version 2 host language compiler, compilation fails because
the operating system does not allow the SQL compiler to open the host object file.
Figure 7-2
illustrates the results of attempting to use a C-series SQL compiler to compile
a host object file compiled by a D-series host language compiler.
Figure 7-1. Results of Using an Older Version SQL Compiler
Node Running
Version 310 NonStop SQL
Node Running
Version 2 NonStop SQL
(Reverted From Version 310)
Compilation attempt results in version error.
1
1
VST015.vsd
PROG1
HOSV=2
PROG2
HOSV=310
Binder
PROGX
HOSV=310
PROGX
HOSV=310
Version 2
SQL Compiler