SQL/MP Version Management Guide

Mixed Version Networks
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
6-4
SQL Programs in a Mixed Version Network
SQL Programs in a Mixed Version Network
The rules determining operation of SQL programs in a mixed version network are
similar to the restrictions controlling SQL/MP software. For example, version errors are
returned when:
•
A catalog residing on a remote node has a version newer than the version of
SQL/MP software running on the same node. In this situation, if an SQL program on
a local node attempts to access objects registered in the catalog running on the
remote node, an error is returned.
•
A catalog residing on a remote node has a version newer than the version of the
SQL/MP software on a local node. In this situation, if an SQL program on the local
node attempts to access objects registered in the remote catalog, an error is also
returned.
For more information on the relationship between the versions of SQL programs and the
versions of objects and catalogs, see Section 5, Program Versions
.
The following additional restrictions apply to SQL programs running in a mixed version
network:
•
No support is provided for compiling SQL programs on remote nodes. You must
host-compile and SQL-compile SQL programs on the node where they are to run,
and you must register the programs in catalogs on the same node where the program
resides. An SQL program cannot be compiled from a remote node.
•
If you execute a CREATE INDEX NO INVALIDATE statement that raises a version
2 table on a version 300 or newer node to version 300 or newer and an SQL
program running on a remote version 1 or version 2 node attempts to access the
table, an error could be returned at execution time. (For more information on this
and other situations that can invalidate programs, see Section 7, Version
Compatibility for SQL Programs.)
Figure 6-3. Access to Newer Version Catalogs
Node Running
Version 315 NonStop SQL/MP
Node Running
Version 2 NonStop SQL
Version 2
Objects
Version 315
Catalog
Version
NonStop SQL Software
Version 2
Catalog
Version 2
Objects
1
1. Error detected.
VST013.vsd