SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
5-5
DOWNGRADE Utility
DOWNGRADE Utility
Considerations for DOWNGRADE
Example of DOWNGRADE
DOWNGRADE is a syntax-based utility that can be executed through MXCI. The
DOWNGRADE transforms all metadata that is visible on the local node from its
existing version to the specified, lower schema version. This includes the schemas in
the system catalog. The REPORTONLY option allows you to test if the operation can be
executed without actually performing the operation.
version
is a valid SQL/MX version number, which specifies the target version of the
command.
[optional output spec]
corresponds to the output options.
Considerations for DOWNGRADE
Command Output for DOWNGRADE
The DOWNGRADE utility supports the following command output options:
•
REPORTONLY
If the REPORTONLY option is specified, only the initial error checking is performed;
the DOWNGRADE operation is not performed. If the LOG TO option is also
specified, the list of affected schemas is written to the output file.
•
LOG TO
If the LOG TO option is specified, the command writes a log of its progress to either
the specified oss-file or to the home terminal. If the CLEAR option is used and if
oss-file is an existing disk file, oss-file is cleared before logging begins.
DOWNGRADE ALL METADATA TO VERSION version
[optional output spec]
optional output spec is:
[ { [ LOG TO ] OUTFILE oss-file
[ CLEAR ] | LOG TO HOMETERM } ] [ REPORTONLY ]
Note. The DOWNGRADE utility is available only on systems running J06.11 and later J-series
RVUs and H06.22 and later H-series RVUs.