SQL/MP Version Management Guide

Program Versions
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
5-2
Host Object SQL Version (HOSV)
COBOL85 preprocessor has the same host language SQL version as the corresponding
COBOL85 compiler. Different releases of a host language compiler or preprocessor can
be compatible with the same host language SQL version.
Before you use a host language compiler on a particular node to compile programs
containing embedded SQL statements, SQL/MP must be installed on the node, and the
host language SQL version of the compiler must be the same as or older than the version
of the installed SQL/MP software.
A host language compiler that supports older versions of SQL/MP can be used on a
node running a newer version of SQL/MP software. For example, you can use an SQL
version 2 host language compiler on a node running version 315 SQL/MP software. The
resulting version 2 host object SQL file can be SQL-compiled by a version 2 or newer
SQL compiler, but not by a version 1 SQL compiler.
Host Object SQL Version (HOSV)
A host object SQL version number (HOSV) is a version number assigned to a host
object file containing SQL code. The host object SQL version of an object code file is
assigned by the host language compiler that compiles the file. The HOSV identifies the
oldest-version SQL compiler that can be used to SQL-compile the file.
The host object version of a file is used to keep a record of changes in the formats of
structures written to the file. Thus, when changes made to SQL structures affect an
object code file, the HOSV of the object code file changes.
When a host language compiler produces a host object file, the compiler stores its own
host object SQL version in the host object file it produces. The COBOL85 preprocessor
also stores its host object SQL version in its host object files. Therefore, the version
number of a host object SQL file matches the version number of the host language
compiler used to compile the program.
For example, if you compile a source program with a version 310 host language
compiler, the version number of the resulting host object SQL file is also 310.
If you bind multiple host object SQL files into a single object file, the version of the
resulting host object SQL file is equal to the newest version of the object files that are
bound together.
For example, if you bind a version 2 object file and a version 310 object file, the version
of the resulting host object SQL file is 310. This version 310 host object SQL file can be
SQL-compiled only by a version 310 or newer-version SQL compiler.