SQL/MP Version Management Guide

Summary of Feature, Catalog, and Data Structure
Changes
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
A-5
Changes to Catalog Tables
•
The addition of the OSSFILE column to the PROGRAMS table causes the catalog
version of the SQL program to become at least 315 when used with SQL/MP
version 315.
Changes to Catalog Tables
The format of catalog tables has been changed in each release. This subsection
summarizes the catalog table changes made with the introduction of each version of the
SQL/MP software through version 315.
For a detailed description of the catalog tables for version 300 and newer software, see
the NonStop SQL/MP Reference Manual.
Although the format of version 1 and version 2 catalog tables differ, version 1 software
is compatible with version 2 catalog tables. For example, you can downgrade version
315 catalogs to versions 300, 310, and 2, but you can downgrade version 300 catalogs
only to version 2.
Catalog Changes in Version 2
In version 2, the format of the COLUMNS and FILES tables changed, and a new value
was allowed for the first time in the COMMENTS table. These changes were made to
support new features introduced in version 2.
In addition to these changes, the lock length for the USAGES table was set to zero to
indicate that the entire primary key length should be used for locking. The lock length
value is stored in the FILES catalog table entry for the USAGES table.
The version of a catalog was maintained in the VERSION columns of the system
catalog CATALOGS and VERSION tables. In this column, a version 1 catalog is
indicated by the entry A010, and a version 2 catalog is indicated by the entry A011.