SQL/MP Version Management Guide

Mixed Version Networks
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
6-8
Version 300 or Newer SQL Utilities in a Mixed
Version Network
As a general rule, SQL programs being executed on nodes running version 1 SQL
should not attempt to access objects on nodes running version 300 or newer SQL
software.
Before you install version 300 or newer software on any node in a network, upgrade the
software on all other nodes running version 1 to the newest version 2 SQL software (that
is, to software released with the newest C30 IPM) to ensure that versioning issues are
handled correctly.
These rules summarize the support provided for version 1 software in mixed version
networks:
•
You can upgrade version 1 catalogs on nodes running version 2 or version 300 or
newer SQL software to a newer version by issuing an UPGRADE CATALOG or
UPGRADE SYSTEM CATALOG statement from a node running version 300 or
newer SQL software.
•
You can continue to execute SQL programs whose format version is 1 (that is,
programs previously compiled by a version 1 SQL compiler) on a node running
version 300 or newer software without recompilation.
•
Version 1 SQL software can access version 1 objects registered in version 2
catalogs. (This rule is an exception to the general versioning rules listed earlier
under Version 2 and Newer Version Software
on page 6-6.)
•
A CREATE CATALOG statement issued from a node running version 1 SQL
software always creates a version 1 catalog, regardless of the version of the SQL
software on the node where the catalog is to reside. For example, you can create a
version 1 catalog on a node running version 300 or newer SQL software.
These version restrictions apply to version 1 SQL software running in mixed version
networks:
•
You cannot use version 1 SQL software to access objects registered in a version 300
or newer catalog.
•
You cannot use a version 1 SQL compiler to compile an object file whose host
object SQL version is 2 or newer; any attempt to do so results in a version error at
compile time.
•
You cannot use a version 1 SQL executor to run an SQL program whose version is 2
or newer (that is, an SQL program compiled by a version 2 or newer SQL compiler);
any attempt to do so results in a run-time version error.
Version 300 or Newer SQL Utilities in a Mixed
Version Network
Two general rules govern the behavior of version 300 or newer SQL utilities used in
mixed version networks. Both these rules apply to networks with nodes running SQL
software that is older or newer than the versions of the SQL utilities:
•
These utilities can operate successfully on objects and programs residing on nodes
running older versions of SQL software. This situation is true unless the utilities