SQL/MP Version Management Guide

Overview of Version Management
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
1-6
Host Language Compiler SQL Version
used in the program. For example, collations are version 300 objects. Therefore, a
program that uses collations must have a program catalog version of at least 300.
Host Language Compiler SQL Version
A host language compiler SQL version number is a version number assigned to host
language compilers and COBOL85 preprocessors used to compile source-code files with
embedded SQL statements. (A COBOL85 preprocessor has the same host language SQL
version as the corresponding COBOL85 compiler.)
The host language compiler version assigned to a compiler or a COBOL85 preprocessor
identifies the oldest version of the SQL software with which the compiler or
preprocessor is compatible.
Host Object SQL Version (HOSV)
A host object SQL version number (HOSV) is a version number assigned to a host
object-code file containing SQL code. The HOSV 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 HOSV is used to keep a record of changes in the formats of structures written to the
object-code file. Thus, when changes made to SQL structures affect an object-code file,
the HOSV of the object file changes.
SQL Compiler Version
A SQL compiler version is the version assigned to an SQL compiler. In a network
installation, the SQL compiler version is always the same as the SQL software version
on the same node.
SQL Executor Version
The SQL executor version number is a version number assigned to an SQL executor. In
a network installation, the SQL executor version is always the same as the SQL software
version running on the same node.
Migration Considerations
An understanding of SQL/MP version management is important when you migrate to a
new version of the software, revert to an older version of the software, or use SQL/MP
in a network with nodes that support more than one version of SQL/MP.
Migrating to a Newer Version
When you migrate to a new version of SQL/MP, you do not have to recompile existing
programs to continue running those programs with the new version of SQL/MP you
have installed. However, if you want to take advantage of new features, you must host
compile and SQL-compile any programs that use the new features with the new versions
of the host and SQL compilers. If you want to take advantage of performance