SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-21
MODIFY LABEL with REPLACE NODENUMBER
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, 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 these 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