SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-32
MODIFY LABEL with REPLACE VOLUME
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 VOLUME volume-name [(node-name1 [,node-name2]
[EXCLUDE node-name3 [,node-name4] ] ) ]
specifies the volume name to be replaced in the file label. SQL file labels contain
file names, and those file names contain volume names. Volume names are
changed based on the node-name list. The volume name specified in REPLACE
VOLUME volume-name clause is replaced by the volume name specified in the
WITH volume-name clause.
If the first node-name list is specified, SQL replaces the volume name only if it
matches the volume name specified by volume-name and if the node name in the
file name matches one of the node names specified in the node-name list. The
optional EXCLUDE node-name list clause specifies node names to be excluded
from the first node-name list.
volume-name must be preceded by a dollar '$' character and must consist of at
least one to six alphanumeric characters. The first character must be alphabetic.
You can specify either uppercase or lowercase alphabetic characters; alphabetic
characters are upshifted before the comparison and substitution process. The
volume-name cannot include wild-card characters.
The first node-name list specifies a node name or a set of node names.
node-name must be preceded by a backslash character. To specify a single node
name, enter the name of the node. To specify multiple node names, use wild-card
characters. You can use these wild-card characters:
For example, \NOD* specifies all nodes that begin with \NOD. *NOD* matches
NEWNODE, OLDNODE1, and NODE45. NOD? matches NOD1 and NODX, but
not NOD or NOD48.
The maximum number of node-names that can be specified in this clause is 10 for
each node-name list. For example, this clause is invalid because it has 11 node
names in the first node-name list:
(\A*,\B*,\C*,\D*,\E*,\F*,\G*,\H*,\I*,\J*,\K* EXCLUDE \Z*)
If this clause is not specified, only the volume name is considered.
* Matches 0 to 8 characters in the position where it appears. Specifying only
an asterisk indicates any name is acceptable. To specify all files, use either
\* or *
?
Matches any single character