NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
M-13
MODIFY LABEL Command
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.
You can also specify a logical DEFINE name as a fileset. File labels for dependent
objects and partitions are not considered for modification unless the dependent
object or partition is specified in simple-fileset-list-1. For example, if
$A.B.T1 is a table that has a dependent index, then specifying $A.B.T1 results in
only the file label of the table being considered; the file label of the index is not
considered.
REPLACE NODENUMBER node-spec [ ( volumeset [,volumeset]
[EXCLUDE volumeset [,volumeset] ] ) ]
from one to seven alphanumeric characters. The first specifies the node number to
replace in the file labels. The node number is replaced by the node number specified
in the WITH node-spec clause.
If the first volumeset list is specified, SQL replaces the node number only if the
node number in the file label matches the node number specified by node1 and the
volume name of the file label matches one of the volume names specified in the first
volumeset list. The optional EXCLUDE volumeset list clause specifies
volumes to be excluded from the first volumeset list.
node-spec specifies a node-number and node-name pair. node-name
specifies a node name, which must be preceded by a character must be alphabetic.
Either uppercase or lowercase alphabetic characters can be specified. node-
number specifies a node number in the range from 0 to 254.
The value of node-spec need not match the node number assigned to the local
node executing the MODIFY command.
volumeset indicates a volume or a set of volumes. To specify a single volume,
enter the name of the volume. To specify multiple volumes use wild-card characters.
You can use the following wild-card characters:
* 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 on all
volumes, use either $*.*.* or *.*.*
? Matches any single character
* Matches 0 to 8 characters in the position where it appears. Specifying only
an asterisk indicates any name is acceptable. To specify all volumes, use
either $* or *
? Matches any single character