SQL/MP Installation and Management Guide

Installing SQL/MP
HP NonStop SQL/MP Installation and Management Guide—523353-004
2-17
Recompiling Programs
•
Drop any program whose program catalog version would be newer than the
version of the catalog after the catalog is downgraded. For example, drop version
310 and newer programs before reverting to version 2.
You cannot downgrade a catalog to version 1, but version 2 catalogs are compatible
with version 1 SQL/MP software if you access only version 1 objects.
For information about catalog, object, and program versions, see the SQL/MP Version
Management Guide.
You must have exclusive access to the catalog tables. You can downgrade more than
one catalog by specifying a catalog name pattern. For a detailed description of the
DOWNGRADE CATALOG command and the requirements for using it, see the
SQL/MP Reference Manual.
Downgrading the System Catalog
Before you can downgrade the system catalog to a version older than 300, you must
drop any version 300 or newer objects registered in the system catalog. You must be
logged on with the super ID.
You cannot downgrade the system catalog to version 1, but version 2 system catalogs
are compatible with version 1 SQL/MP software.
For a description of the syntax and more examples of using the DOWNGRADE
SYSTEM CATALOG command, see the SQL/MP Reference Manual.
Recompiling Programs
If you want to use a program compiled with a version 300 or newer SQL compiler (a
program whose program format version is 300 or newer), you must recompile the
program with the older-version SQL host compiler compatible with the version of
SQL/MP you have reinstalled, and then SQL compile the program with the appropriate
SQL compiler.
Reverting to SQL/MP Version 2
To revert to version 2 of SQL/MP:
1. If you have any version 300 or newer tables you want to preserve, use the
CREATE TABLE statement to create version 2 tables to contain any version 2 data
you want to preserve, and use the LOAD utility to move the data from the version
300 tables to the version 2 tables.
2. Use the DROP statement to drop version 300 or newer tables, indexes, views, and
collations.