SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
V-7
SQL/MP Component Versions
SQL/MP Component Versions
Each component of the SQL/MP software has a version. Except for the message file,
all SQL/MP software components on any one node in a network must have the same
product version. SQL/MP software on different nodes in the same network can have
different product versions.
The message file used by SQLCI also has a version. SQLCI can execute with a
version of the message file that is older than the version of the other SQL/MP software
on the node, but some messages might be missing or inaccurate as a result. (SQLCI
issues a warning if you start an SQLCI session that uses an older version of the
message file.)
A given version of SQL/MP software can operate on SQL objects registered in catalogs
with the same version as the software or in catalogs with an older version than the
software. A version of SQL/MP software cannot operate on objects registered in
catalogs with a newer version than the software.
The command GET VERSION OF SYSTEM returns the version of SQL/MP software
installed on a node.
Catalog Versions
Each SQL/MP catalog has a version that indicates the newest-version object you can
register in the catalog.
When you create a catalog using SQL/MP software of version 300 or later, NonStop
SQL/MP assigns the new catalog the version of the SQL software running on the node
on which the catalog resides. You can change the version with UPGRADE CATALOG
or DOWNGRADE CATALOG, but no catalog can have a newer version than the
software on the catalog's node, or an older version than that of the newest-version
object registered in the catalog.
A system catalog follows the same rules as any other catalog except that you use
UPGRADE SYSTEM CATALOG and DOWNGRADE SYSTEM CATALOG to change
the version. A system catalog can also register user catalogs of newer versions
(because these are not considered SQL/MP objects) but cannot register objects of
newer versions.
The command GET VERSION OF CATALOG returns the version of a catalog.
Object Versions
Each SQL/MP object (table, view, index, constraint, or collation) has a version that
indicates the oldest version of NonStop SQL/MP that can support that object.
The version of an object depends on the features used in the object and in other
objects on which that object depends. For example, if you create a table that uses only
features that were available in version 1 of NonStop SQL/MP, the table is associated
with version 1, even if you create it with version 315 software. If you add a column to