SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-6
MODIFY CATALOG with REPLACE NODENAME
To specify a single catalog, enter the name of the catalog (the name of the
subvolume that contains the catalog). To specify multiple catalogs in a
catalogset, use wild-card characters. You can use these wild-card characters:
For example, $DATA.* specifies all catalogs on the volume $DATA, and *.*
specifies all catalogs on the node. *VOL* matches NEWVOL, OLDVOL1, and
VOL45. VOL? matches VOL1 and VOLX, but not VOL or VOL48.
The MODIFY CATALOG with REPLACE NODENAME command assumes that a
subvolume contains a valid catalog if the subvolume contains the catalog table
TABLES (file code must be 581). The optional EXCLUDE catalog-list-2
clause specifies catalogs to be excluded from catalog-list-1.
REPLACE NODENAME node-name [ ( volumeset [,volumeset]
[EXCLUDE volumeset [,volumeset] ] ) ]
specifies the node name to replace in the catalog tables. SQL catalog tables
contain file names, and those file names contain node names. Node names are
changed based on the volumeset list. Each node name is replaced by the node
name specified in the WITH node-name clause.
If the first volumeset list is specified, SQL replaces the node name only if it
matches the node name specified by node-name and if the volume name in the
file name matches one of the volume names specified in the volumeset list. The
optional EXCLUDE volumeset list clause specifies volumes to be excluded from
the first volumeset list.
node-name must be preceded by a backslash character and must consist of from
one to seven 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 first volumeset list specifies 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:
For example, $DAT* specifies all volumes that begin with $DAT. *VOL* matches
NEWVOL, OLDVOL1, and VOL45. VOL? matches VOL1 and VOLX, but not VOL
or VOL48.
* Matches 0 to 8 characters in the position where it appears. Specifying only
an asterisk indicates any name is acceptable. To specify all catalogs, 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