SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
V-8
Program Versions
the table that has the NCHAR data type, however, the version of the table becomes
version 300 (because the NCHAR data type is first supported in version 300).
Because the version of an object affects the version of any object that depends upon
that object, changing the version of an object can automatically change the version of
other objects that depend on that object. For example, adding an index that has a
newer version than the associated table changes the version of the table. If the table
has a dependent view, the operation also changes the version of the view.
The GET VERSION command returns the version of a table, view, index, or collation.
Program Versions
Each compiled SQL/MP program has three different versions associated with it:

The host object SQL version (HOSV) is the version of the host language compiler
that compiled the program. It indicates the oldest version of the SQL compiler that
can compile the program.

The program catalog version (PCV) is the version of the newest-version SQL
feature used in the program. It indicates the oldest version of a catalog that can
register the program. A program can access objects with versions older or newer
than the PCV of the program, but a program cannot be registered in a catalog that
has a version older than the PCV of the program.

The program format version (PFV) is the version of the SQL compiler that compiled
the program. It indicates the oldest version of SQL/MP software that can execute
the program and the newest version of objects that the program can access. A
program can be registered in a catalog that has a version older or newer than the
PFV of the program, but a program cannot access an object that has a version
newer than the PFV of the program.
A host language compiler cannot have a newer version than the SQL/MP software on
the same node, but can have an older version.
Host language compiler versions
Each host language compiler that supports SQL/MP has a version that indicates the
oldest version of SQL/MP software that can SQL-compile object programs produced by
the host language compiler. The version of the host language compiler becomes the
host object SQL version (HOSV) of the object programs it produces.
The GET VERSION OF PROGRAM command returns the HOSV, PCV, or PFV of a
program.