SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-23
MODIFY LABEL with REPLACE NODENUMBER
ALLOWERRORS [ OFF | ON | number-of-errors ]
determines handling of nonfatal errors. MODIFY LABEL with REPLACE
NODENUMBER reports two classes of errors: fatal errors and nonfatal errors. The
MODIFY LABEL with REPLACE NODENUMBER 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.
The description of each MODIFY LABEL with REPLACE NODENUMBER error
states whether the error is fatal or nonfatal.
When MODIFY LABEL with REPLACE NODENUMBER continues processing after
a nonfatal error has occurred, it advances to the next SQL object or object
program.
[ NO ] LISTALL
specifies how much information MODIFY LABEL with REPLACE NODENUMBER
writes to the current OUT file. If LISTALL is specified, MODIFY reports the name of
each SQL object and object program whose label was considered for modification
and indicates whether or not the object or program was modified. If NO LISTALL is
specified, only summary information is reported.
LISTALL is the default.
DETAIL [ MATCH | ALL ] REPORT [ TO EMS-Collector]
[ ON ]
[ OFF ]
specifies that detailed about the MODIFY LABEL with REPLACE NODENUMBER
operation is to be sent in event messages to a valid EMS collector.
If MATCH is specified, detail is reported about SQL objects and object programs
specified in target-spec that contain node numbers matching the criteria
OFF The MODIFY LABEL with REPLACE NODENUMBER
command terminates immediately after the first
nonfatal error is encountered.
ON THE MODIFY LABEL with REPLACE
NODENUMBER command continues, regardless of
the number of nonfatal errors encountered.
number-of-errors The MODIFY LABEL with REPLACE NODENUMBER
command continues until the number of nonfatal
errors exceeds the value of number-of-errors.