SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-18
Examples-MODIFY CATALOG with REPLACE
VOLUME
Examples-MODIFY CATALOG 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 will be 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 catalog \SYS.$VOL.CAT1.
--- \SYS.$VOL.CAT1 was modified.
Checking catalog \SYS.$VOL.CAT2.
--- \SYS.$VOL.CAT2 was not modified.

The following summary information is included whether you specify LISTALL or NO
LISTALL:
Summary Information:
nnn catalog(s) require modification.
nnn catalog(s) do not require modification.