SQL/MP Version Management Guide

Overview of Version Management
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
1-2
Version Management Conventions
Each time a new version of SQL/MP software is released, all programs that ran
correctly under previous versions must also run correctly on the new version,
without recompilation.
To implement these requirements, SQL/MP associates version numbers with SQL/MP
software, catalogs, objects, message files, and programs, and with the host language
compilers used to compile source files containing SQL code. These version numbers are
directly related to releases of SQL/MP software.
Version Management Conventions
•
On any particular node in a network, all SQL/MP software components must have
the same version number. (SQL/MP components include the SQL compiler and
SQL executor, the SQL catalog manager, the SQLCI conversational interface, the
SQL utilities, and the BACKUP and RESTORE utilities.)
•
The version of the system catalog used in a database installation can be older than
the version of user catalogs registered in the system catalog. However, the system
catalog version cannot be older than the version of any objects or programs
registered in the system catalog.
•
Host language compilers that support a particular version of SQL/MP cannot run on
a node where an older version of SQL/MP is installed. Attempts to violate this rule
can cause unpredictable results. However, an older version of a host language
compiler can run on a node where a newer version of SQL/MP is installed.
•
The versions of message files used with SQL/MP software do not have to be the
same as the version of SQL/MP software being used.
•
SQL/MP does not support access to objects or programs registered in remote SQL
catalogs if either of the following conditions is true:
•
The version of the object or program registered in the remote SQL catalog is newer
than the version of the software on the node where the catalog resides.
•
The version of the object or program registered in the remote SQL catalog is newer
than the version of the accessing software.
These last few restrictions apply even if the versions of the objects or programs
registered in the remote catalog are the same as or older than the version of SQL/MP
software running on the local node.
New Versions, Old Versions, and Future Versions
The terms newer version, older version, and future version are often used in discussing
SQL/MP software and its components, catalogs, objects, programs, and host compilers.
In this manual, these three terms are used:
•
Newer version
A SQL/MP product with a newer version is one that has a newer release date and a
higher version number than a product to which it is being compared. The term
newer version does not refer to the date or time when the software was installed, the