SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-14
MODIFY CATALOG with REPLACE VOLUME
volume-name must be preceded by a dollar '$' character and consist of at least
one to six alphanumeric characters. The first character must be alphabetic. Either
uppercase or lowercase alphabetic characters can be specified; alphabetic
characters are upshifted before the comparison and substitution process.
ALLOWERRORS [ OFF | ON | number-of-errors ]
determines handling of nonfatal errors. MODIFY reports two classes of errors: fatal
errors and nonfatal errors. The MODIFY CATALOG command terminates
immediately after reporting a fatal error. Nonfatal errors are handled depending on
the value of the ALLOWERRORS option:
If you specify ALLOWERRORS without ON, OFF, or the number of errors,
ALLOWERRORS ON is the default. If you do not specify the ALLOWERRORS
option, ALLOWERRORS OFF is the default.
When MODIFY CATALOG with REPLACE VOLUME continues processing after a
nonfatal error has occurred, it advances to the next SQL catalog.
[ NO ] LISTALL
specifies how much detail MODIFY CATALOG with REPLACE VOLUME writes to
the current OUT file. If LISTALL is specified, MODIFY CATALOG with REPLACE
VOLUME reports the name of each SQL catalog considered for modification and
whether or not the catalog was modified. If NO LISTALL is specified, only summary
is reported.
LISTALL is the default option.
DETAIL [ MATCH | ALL ] REPORT [ TO EMS-Collector ]
[ ON ]
[ OFF ]
specifies that details about the MODIFY CATALOG with REPLACE VOLUME
operation is to be sent in event messages to a valid EMS collector.
If MATCH is specified, details are reported about SQL catalog tables specified in
target-spec that contain volume names that match the criteria specified in the
OFF The MODIFY CATALOG with REPLACE VOLUME
command terminates immediately after the first nonfatal
error is encountered
ON THE MODIFY CATALOG with REPLACE VOLUME
command continues, regardless of the number of nonfatal
errors encountered.
number-of-errors The MODIFY CATALOG with REPLACE VOLUME
command continues until the number of nonfatal errors
exceeds value of number-of-errors.