SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-27
Examples—MODIFY LABEL with REPLACE
NODENUMBER
The MODIFY DICTIONARY utility does not modify the node names in the DEFINE
set stored in the object program file.

After the DEFINEs are changed by the user, if automatic recompilation is enabled
the programs are automatically recompiled using the new DEFINEs.

A catalog and the objects registered in it must be on the same node. However, it is
possible for an object to be on a different disk than its catalog. The MODIFY
DICTIONARY utility is not intended to correct the situation where a disk containing
objects is moved to a new node, but the disk containing the associated catalog is
not moved to the new node.

The MODIFY LABEL with REPLACE NODENUMBER command returns a nonfatal
versioning error if an SQL object is newer than the version of MODIFY
DICTIONARY accessing it, if the PCV of an SQL program is newer than the
version of MODIFY that is accessing it, or if the object or program has a version
newer than the version of SQL/MP system software on the node where the object
or program resides.
Examples—MODIFY LABEL with REPLACE NODENUMBER
The first group of examples show the REPLACE clause.

In this 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 this 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 this 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 this REPLACE clause, node number 24 is replaced with node number 100:
REPLACE NODENUMBER 24 WITH 100

In this REPLACE clause, node number 24 is replaced with the node number
associated with the node name \SQL:
REPLACE NODENUMBER 24 WITH \SQL

In this 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)