SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-20
MODIFY LABEL with REPLACE NODENUMBER
simple-fileset-list-1 [ EXCLUDE simple-fileset-list-2 ]
identifies one or more SQL objects and object programs whose file labels will be
considered for modification. File labels are modified only if they contain node
numbers that match the criteria specified in the REPLACE clause. Files included in
simple-fileset-list-1 that are not SQL objects or SQL program files are
ignored.
The optional EXCLUDE simple-fileset-list-2 clause specifies files to be
excluded from simple-fileset-list-1.
fileset is a Guardian name in which wild-card characters can be used to specify
volumes, subvolumes, files, and objects. You cannot use wild-card characters in
node names.
MODIFY [DICTIONARY] LABEL target-spec replace-spec
WITH node-spec [ [,] option ] ... ;
target-spec is:
simple-fileset-list-1 [EXCLUDE simple-fileset-list-2]
replace-spec is:
REPLACE NODENUMBER node-spec[(volumeset[,volumeset]
[EXCLUDE volumeset [,volumeset] ] ) ]
option is:
[| ALLOWERRORS [ OFF | ON | number-of-errors ] |]
[| [ NO ] LISTALL |]
[| DETAIL [ MATCH | ALL ] REPORT [ TO EMS-Collector ]|]
[| [ ON ] |]
[| [ OFF ] |]
[| CHECKONLY |]
simple-fileset-list-n (where n = 1,2) is:
{ fileset }
{ ( fileset [ , fileset ] ... ) }
node-spec is:
{ ( node-name , [node-number] ) }
{ ( node-number , [node-name] ) }