SQL/MP Version Management Guide

Database Versions
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
3-6
Where Catalog Versions Are Stored
CATALOGFORMAT. The values in the VERSION column of a version 300 or newer
catalog are maintained for compatibility with versions 1 and 2.
The catalog version in the CATALOGVERSION and CATALOGFORMAT columns of
a VERSIONS table is recorded in integer format, which is compatible with SQL/MP
software and with SQL object and program versions.
This table lists the contents of the VERSION, CATALOGVERSION, and
CATALOGFORMAT columns in a VERSIONS table. (The CATALOGVERSION and
CATALOGFORMAT columns do not exist in version 1 and version 2 catalogs.)
For a description of the attributes of these columns, see the NonStop SQL/MP Reference
Manual.
CATALOGS Table in the System Catalog
Depending on the version of the system catalog being referred to, catalog version
information is recorded in one or two columns of the CATALOGS table.
A version 2 CATALOGS table contains only a VERSION column. A version 300 or
newer CATALOGS table contains version information in both the VERSION and
CATALOGVERSION columns. Values in the VERSION column of a version 300 or
newer CATALOGS table are maintained for compatibility with versions 1 and 2.
The catalog version information in the CATALOGVERSION column is recorded in
integer format, which is compatible with SQL/MP software and SQL object and
program versions.
This table lists the contents of the VERSION and CATALOGVERSION columns of a
version 315 catalog. Catalog version information can be recorded in the CATALOGS
table for version 1, version 2, and version 300 or newer catalogs.
VERSION
Column
CATALOGVERSION
Column
CATALOGFORMAT
Column
Catalog
Version
“A010” Version 1
“A011” Version 2
“A300” 300 300 Version 300
“A310” 310 310 Version 310
“A315” 315 315 Version 315
Version
Column
CATALOGVERSION
Column
Catalog
Version
“A010” 1 Version 1
“A011” 2 Version 2
“A300” 300 Version 300
“A310” 310 Version 310
“A315” 315 Version 315