SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-13
MODIFY CATALOG with REPLACE VOLUME
TABLES (file code must be 581). The optional EXCLUDE catalog-list-2 clause
specifies catalogs to be excluded from catalog-list-1.
REPLACE VOLUME volume-name [(node-name1 [,node-name2]
[EXCLUDE node-name3 [,node-name4] ] ) ]
specifies the volume name to be replaced in the catalog tables. SQL catalog tables
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.
WITH volume-name
specifies the volume name to replace occurrences of the volume name specified in
replace-spec.
* 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