SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-37
Examples-MODIFY LABEL with REPLACE
VOLUME
Examples-MODIFY LABEL with REPLACE VOLUME
These examples illustrate the use of the REPLACE clause.

In this example, the volume name $DATA is replaced with the volume name $NEW
if the first three characters of the node name are \DA:
REPLACE VOLUME $DATA (\DA*) WITH $NEW

In this REPLACE clause, the volume name $DATA is replaced with the volume
name $NEW if the node name is either \SAM or \IND or if the first three characters
of the node name are \DA:
REPLACE VOLUME $DATA (\SAM,\IND,\DA*) WITH $NEW

In this REPLACE clause, the volume name $DATA is replaced with the volume
name $NEW if the node name is anything other than \IND:
REPLACE VOLUME $DATA (\* EXCLUDE \IND) WITH $NEW

When you use the CHECKONLY option, note that the amount of information
written to the current OUT file depends on whether LISTALL or NO LISTALL is
specified. The MODIFY CATALOG command produces this display for each
catalog when 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.

This example on 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.

The MODIFY LABEL with REPLACE VOLUME command produces this display
when requested with the LISTALL option:
Checking \SYS.$VOL.SUBVOL.T1 label.
--- \SYS.$VOL.SUBVOL.T1 label was modified.
Checking \SYS.$VOL.SUBVOL.T2 label.
--- \SYS.$VOL.SUBVOL.T2 label was not modified.