SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-31
MODIFY LABEL with REPLACE VOLUME
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 volume
names 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. The wild-card characters you can use are:
For example, *VOL* matches NEWVOL, OLDVOL1, and VOL45. $VOL1.SUBV1.*
specifies all files on subvolume SUBV1 of volume $VOL1, and \SYS1.*.SUBV1.*
specifies all files on all subvolumes named SUBV1 on any volume of node \SYS1.
TABLE? matches TABLE1 and TABLEX, but not TABLE or TABLE48.
MODIFY [DICTIONARY] LABEL target-spec replace-spec
WITH volume-name [ [,] option ] ... ;
target-spec is:
simple-fileset-list-1 [ EXCLUDE simple-fileset-list-2 ]
replace-spec is:
REPLACE VOLUME volume-name [ ( node-name1 [,node-name2]
[EXCLUDE node-name3 [,node-name4]… ] ) ]
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 ] ... ) }
* Matches 0 to 8 characters in the position where it appears. Specifying only
an asterisk indicates that any name is acceptable. To specify all files, use
either $*.*.* or *.*.*
? Matches any single character