SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-41
MODIFY REGISTER Command
For example, $DATA.* specifies all catalogs on the volume $DATA, while *.*
specifies all catalogs on the node. *VOL* matches NEWVOL, OLDVOL1, and
VOL45. VOL? matches VOL1 and VOLX but not VOL or VOL48.
The MODIFY REGISTER command functions requires that a subvolume contains
a valid catalog if the subvolume contains the catalog table TABLES (file code must
be 581).
ALLOWERRORS [ OFF | ON | number-of-errors ]
determines handling of nonfatal errors. MODIFY REGISTER reports two classes of
errors: fatal errors and nonfatal errors. The MODIFY command always terminates
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 ALLOWERRORS, ALLOWERRORS OFF is the default.
When MODIFY REGISTER continues processing after a nonfatal error has
occurred, it advances to the next SQL catalog.
Each MODIFY REGISTER error describes whether the error is fatal or nonfatal.
[ NO ] LISTALL
specifies how much information MODIFY REGISTER writes to the current OUT
file. If LISTALL is specified, MODIFY REGISTER reports the name of each SQL
catalog registered. If NO LISTALL is specified, only summary information is
reported.
LISTALL is the default.
OFF The MODIFY REGISTER command terminates
immediately after the first nonfatal error is
encountered.
ON The MODIFY REGISTER command continues,
regardless how many nonfatal errors are
encountered.
number-of-errors The MODIFY REGISTER command continues until
the number of nonfatal errors exceeds the value of
number-of-errors.