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-412
Considerations for UPGRADE
catalog
specifies the ANSI name of the catalog in which metadata is to be upgraded. There
is no default for catalog.
RESTRICT
restricts the upgrade to metadata in the named catalog only.
CASCADE
extends the upgrade to the transitive closure of catalogs that are related to the
specified catalog. If no option is specified, the default is CASCADE.
output-spec
corresponds to the output options.
Considerations for UPGRADE
Modes of Operation for UPGRADE
The following are two modes of operation for the UPGRADE utility:
•
ALL METADATA
This mode of operation upgrades all metadata that is visible on the system,
including the metadata in the system catalog.
•
ALL METADATA IN CATALOG catalog
This mode of operation upgrades all the metadata in the named catalog. If the
CASCADE option is specified, it affects the metadata in the catalogs that are related
to the named catalog. This mode of operation is available in SQL/MX Release
3.2 and later releases.
Command Output for UPGRADE
The UPGRADE utility supports the following command output options:
•
REPORTONLY
If the REPORTONLY option is specified, only the initial error checking is performed
and no upgrading takes place. If the LOG TO option is also specified, the list of
affected schemas to be upgraded 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
Note. The UPGRADE utility is available only on systems running J06.11 and later J-series
RVUs and H06.22 and later H-series RVUs.