SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-33
MODIFY LABEL with REPLACE VOLUME
WITH volume-name
specifies the volume name to replace occurrences of the volume name specified in
replace-spec.
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 LABEL with REPLACE VOLUME
command terminates immediately after reporting a fatal error. Nonfatal errors are
handled depending on the value of the ALLOWERRORS option:
If you specify ALLOWERRORS option 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 the MODIFY LABEL with REPLACE VOLUME command continues
processing after a nonfatal error has occurred, it advances to the next SQL file.
[ NO ] LISTALL
specifies the detail MODIFY LABEL with REPLACE VOLUME writes to the current
OUT file. If LISTALL is specified, MODIFY LABEL with REPLACE VOLUME
reports the name of each SQL file label considered for modification and whether or
not the file label was modified. If NO LISTALL is specified, only the summary is
reported.
LISTALL is the default option.
OFF The MODIFY LABEL with REPLACE VOLUME
command terminates immediately after the first
nonfatal error is encountered.
ON THE MODIFY LABEL with REPLACE VOLUME
command continues, regardless of the number of
nonfatal errors encountered.
number-of-errors The MODIFY LABEL with REPLACE VOLUME
command continues until the number of nonfatal
errors exceeds value of number-of-errors.