SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-7
MODIFY CATALOG with REPLACE NODENAME
The maximum number of volumesets that can be specified in this clause is 10 for
each volumeset list. For example, this clause is invalid because it has 11
volumes in the first volumeset list:
($A*,$B*,$C*,$D*,$E*,$F*,$G*,$H*,$I*,$J*,$K* EXCLUDE $Z*)
If this clause is not specified, only the node name is considered.
WITH node-name
specifies the node name to replace occurrences of the node name specified in
replace-spec.
node-name must be preceded by a backslash character and consist of from one
to seven 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 with REPLACE NODENAME
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 NODENAME 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 NODENAME writes
to the current OUT file. If LISTALL is specified, MODIFY CATALOG with REPLACE
NODENAME 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.
OFF The MODIFY CATALOG with REPLACE NODENAME
command terminates immediately after the first
nonfatal error is encountered.
ON THE MODIFY CATALOG with REPLACE
NODENAME command continues, regardless of the
number of nonfatal errors encountered.
number-of-errors The MODIFY CATALOG with REPLACE NODENAME
command continues until the number of nonfatal
errors exceeds value of number-of-errors.