SQL/MP Version Management Guide

Overview of Version Management
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
1-4
SQL/MP Software Version
SQL/MP Software Version
A SQL/MP version is the version assigned to the software components that make up the
SQL/MP relational database management system. These components are installed when
you install SQL/MP. The components of the SQL/MP software are listed under SQL/MP
Software Components on page 2-3. All SQL/MP components on the same node have the
same version.
Catalog Version
A catalog version number is a version number assigned to a SQL/MP user catalog or
system catalog and identifies the newest version of SQL objects that can be registered in
the catalog. The number is determined by the version of the SQL/MP software used to
create a catalog.
When a new version of SQL/MP software is released because of the introduction of a
new feature, a new catalog version number is also assigned, although the new feature
might not affect the physical structure or the contents of the catalog.
A different version number, the catalog format version, reflects the physical structure of
a catalog. The catalog format version number, unlike the catalog version number,
changes only when the physical structure of a catalog changes, as explained under
Catalog Format Version
on page 1-4.
Catalog Format Version
A catalog format version number is another version number assigned to an SQL user
catalog or SQL system catalog. The catalog format version of an SQL catalog
Program catalog version
(PCV)
SQL programs Identifies the oldest version of the
catalog in which the program can be
registered
Host language compiler
SQL version
Host language
compilers and
COBOL85
preprocessors
Identifies the oldest version of the
SQL/MP software with which the
host language compiler or
COBOL85 preprocessor is
compatible
Host object SQL version
(HOSV)
Host object files Identifies the oldest-version SQL
compiler that can be used to SQL
compile the host object file
SQL/MP compiler
version
SQL compilers Identifies the version of the SQL
compiler
SQL/MP executor
version
SQL executors Identifies the version of the SQL
executor
Table 1-1. Version Numbers Used to Describe SQL/MP Products (page 2 of 2)
Type of Version Number
Numbered Product,
Program, or Object Purpose of Version Number