NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
M-10
Examples—MODIFY CATALOG
the program is SQL compiled is saved in the object program file. If objects or object
programs specified by the DEFINEs are moved between the time that the program is
SQL compiled and the time that the program is executed, the DEFINEs must be
changed to reflect the new location of the objects and object programs. This
guideline is true regardless of how the database was moved and regardless of
whether the MODIFY DICTIONARY utility was used to modify the node names
and numbers.
The MODIFY DICTIONARY utility does not modify 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.
•
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 CATALOG command returns a nonfatal versioning error if an SQL
catalog has a version newer than the version of MODIFY that is accessing it, or if
the catalog has a version newer than the version of NonStop SQL/MP system
software on the node where the catalog resides.
Examples—MODIFY CATALOG
The following examples illustrate the use of the REPLACE clause.
•
In this example, the node name \TESS is replaced with the node name \FOXII if the
first three characters of the volume name are $DA:
REPLACE NODENAME \TESS ($DA*) WITH \FOXII
•
In the following REPLACE clause, the node name \TESS is replaced with the node
name \FOXII if the volume name is either $SAM or $CAT or if the first three
characters of the volume name are $DA:
REPLACE NODENAME \TESS ($SAM,$CAT,$DA*) WITH \FOXII
•
In the following REPLACE clause, the node name \TESS will be replaced with the
node name \FOXII if the volume name is anything other than $SYSTEM:
REPLACE NODENAME \TESS ($* EXCLUDE $SYSTEM) WITH \FOXII
•
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 the following 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.