SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005

2-174

DOWNGRADE Utility

Considerations for DOWNGRADE

Example of DOWNGRADE

DOWNGRADE is a syntax-based utility that you can run from MXCI. DOWNGRADE

transforms metadata from the existing version to a specified lower version. The

REPORTONLY option allows you to test if the operation can be executed without

actually performing the operation.

Starting with SQL/MX Release 3.2, the DOWNGRADE utility can downgrade all

metadata in a named catalog, and optionally in all catalogs related to the specified

catalog.

catalog

specifies the ANSI name of the catalog, whose metadata is to be downgraded.

There is no default for catalog.

version

is a valid SQL/MX version number which specifies the target version of the

command. version must be lower than the actual schema version for all

schemas affected by the command.

RESTRICT

restricts the downgrade to only the metadata in the named catalog.

CASCADE

extends the downgrade to the transitive closure of catalogs that are related to the

specified catalog. The default is RESTRICT.

DOWNGRADE ALL METADATA TO VERSION version

[ output-spec ]

DOWNGRADE ALL METADATA IN CATALOG catalog TO VERSION version

[ RESTRICT | CASCADE ]

[ output-spec ]

output-spec is:

[ log-to-spec ] [ REPORTONLY ]

log-to-spec is:

{ [ LOG TO ] OUTFILE oss-file [ CLEAR ] | LOG TO HOMETERM }