NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
M-19
Examples—MODIFY LABEL
•
In the following REPLACE clause, node number 24 is replaced with node number
75 if the first three characters of the volume name are $DA:
REPLACE NODENUMBER 24 ($DA*) WITH 75
•
In the following REPLACE clause, node number 100 is replaced with node number
175 if the volume name is either $SAM or $CAT or if the first three characters of
the volume name are $DA:
REPLACE NODENUMBER 100 ($SAM,$CAT,$DA*) WITH 175
•
In the following REPLACE clause, node number 100 is replaced with node number
175 if the volume name is anything other than $SYSTEM:
REPLACE NODENUMBER 100 ($* EXCLUDE $SYSTEM) WITH 175
•
In the following REPLACE clause, node number 24 is replaced with node number
100:
REPLACE NODENUMBER 24 WITH 100
•
In the following REPLACE clause, node number 24 is replaced with the node
number associated with the node name \SQL:
REPLACE NODENUMBER 24 WITH \SQL
•
In the following REPLACE clause, node number 24 is replaced with the node
number 100 if 100 is the node number associated with the node name \SQL:
REPLACE NODENUMBER 24 WITH (\SQL,100)
•
In the following REPLACE clause, the node number associated with the node name
\SQLNLS is replaced with the node number associated with the node name \SQL:
REPLACE NODENUMBER \SQLNLS WITH \SQL
•
In the following REPLACE clause, node number 50 is replaced with the node
number 100 if 50 is the node number associated with the node name \SQLNLS and
100 is the node number associated with the node name \SQL:
REPLACE NODENUMBER (\SQLNLS,50) WITH (\SQL,100)
•
The following example lists the display for each object when CHECKONLY is
requested with the LISTALL option:
Checking \SYS.$VOL.SUBVOL.T1 label.
--- \SYS.$VOL.SUBVOL.T1 label requires modification.
Checking \SYS.$VOL.SUBVOL.T2 label.
--- \SYS.$VOL.SUBVOL.T2 label does not require modification.
•
The following summary information is displayed for CHECKONLY if you specify
either LISTALL or NO LISTALL:
Summary Information:
nnn label(s) require modification.
nnn label(s) do not require modification.