SQL/MP Version Management Guide

Program Versions
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
5-8
Where SQL Program Versions Are Stored
Program Format Version in Catalog Tables
In a version 300 or newer catalog, the SQL/MP compiler stores the PFV of every SQL
program in the PROGRAMFORMATVERSION column of the PROGRAMS table. A
PFV of 1 or 2 can be stored in a version 300 or newer PROGRAMS table.
The PFV of a program registered in a version 1 or version 2 catalog is not defined.
Therefore, in a version 1 or version 2 catalog, a zero value is stored in the
PROGRAMFORMATVERSION column of the PROGRAMS table.
The possible contents of the PROGRAMFORMATVERSION column in the
PROGRAMS table are:
For a description of the column attributes of the PROGRAMS table, see the NonStop
SQL/MP Reference Manual.
Program Catalog Version in Catalog Tables
In a version 300 or newer catalog, the SQL compiler stores the PCV of an SQL program
in the PROGRAMCATALOGVERSION column of the PROGRAMS table. A PCV of 1
can be recorded in a version 300 or newer PROGRAMS table. There is no version 2
PCV.
The catalog version of a program registered in a version 1 or version 2 catalog is not
defined. Therefore, in a version 1 or version 2 catalog, a zero value is stored in the
PROGRAMCATALOGVERSION column of the PROGRAMS table.
The possible contents of the PROGRAMCATALOGVERSION column in the
PROGRAMS table are:
For a description of the column attributes of the PROGRAMS table, see the NonStop
SQL/MP Reference Manual.
0 Program registered in version1 or version 2
catalog
300 Program compiled with version 300 SQL compiler
310 Program compiled with version 310 SQL compiler
315 Program compiled with version 315 SQL compiler
0
Program registered in version 1 or version 2 catalog
1 Program that uses no features requiring a catalog newer than version 1 in
which to register the program
300 Program that uses features requiring at least a version 300 catalog in which
to register the program
310 Program that uses features requiring at least a version 310 catalog in which
to register the program
315 Program that uses features requiring at least a version 315 catalog in which
to register the program