SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-22
MODIFY LABEL with REPLACE NODENUMBER
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.
The maximum number of volumesets that can be specified in this clause is 10 for
each volumeset list. For example, this clause is invalid because it has 11
volumesets in the first volumeset list:
($A*,$B*,$C*,$D*,$E*,$F*,$G*,$H*,$I*,$J*,$K* EXCLUDE $AA*)
If this clause is not specified, only the node number is considered.
WITH node-spec
specifies the node number to replace occurrences of the node number specified by
replace-spec.
node-spec specifies a node-number, node-name, or both. node-number
specifies a node number in the range from 0 to 254. node-name specifies a node
name, which must be preceded by a backslash character and can consist of from
one to seven alphanumeric characters. The first character must be alphabetic.
Either uppercase or lowercase alphabetic character can be specified.
The MODIFY LABEL with REPLACE NODENUMBER command must be able to
identify a valid node number from the information given. The MODIFY LABEL with
REPLACE NODENUMBER command determines the node number:

If you specify a recognized node name and do not specify a node number, the
corresponding node number is used.

If you specify only a node name and the name is not known, SQL returns a
fatal error and the command terminates. An unknown name cannot be mapped
to a known node number.

If the specified node name and node number are both unknown, SQL returns a
warning message noting that the node name and number are unknown and
that the node name is being ignored. It then proceeds with the request, using
the specified node number.

If both a node name and number are specified, and both refer to a known
node, both must refer to the same node. Otherwise, SQL returns an error.
The value of node-spec need not match the node number assigned to the local
node executing the MODIFY command.