SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-28
Examples—MODIFY LABEL with REPLACE
NODENUMBER

In this 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 this 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)

This 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.

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.

This MODIFY LABEL with REPLACE NODENUMBER 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.

This example on summary information is included whether you specify LISTALL or
NO LISTALL:
Summary Information:
nnn label(s) modified.
nnn label(s) not modified.
MODIFY LABEL with REPLACE NODENUMBER and
Partitioned Objects
This example shows the usage of MODIFY LABEL with REPLACE NODENUMBER
when you move partitioned objects.
Suppose that you have table T1 with one partition at \A.$DA1.SQL.T1, a second
partition at \A.$DB1.SQL.T1, and a third partition at \C.$DC1.SQL.T1. The catalogs
where the partitions are registered contain references to the other partitions. For
example, the catalog where \A.$DA1.SQL.T1 is registered contains a reference in the
PARTNS catalog table to all three partitions, and likewise for the catalogs where
\A.$DB1.SQL.T1 and \C.$DC1.SQL.T1 are registered.