SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-38
MODIFY LABEL with REPLACE VOLUME and
Partitioned Objects

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 VOLUME and Partitioned
Objects
This example shows the usage of the MODIFY LABEL with REPLACE VOLUME
command 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.
This SELECT statement illustrates the example:
>> SELECT FILENAME,PARTITIONNAME,CATALOGNAME
+> FROM \A.$DA1.CATSUBV.PARTNS;
FILENAME PARTITIONNAME CATALOGNAME
-------------- -------------- ---------------
\A.$DA1.SQL.T1 \A.$DA1.SQL.T1 \A.$DA1.CATSUBV
\A.$DA1.SQL.T1 \A.$DB1.SQL.T1 \A.$DB1.CATSUBV
\A.$DA1.SQL.T1 \C.$DC1.SQL.T1 \C.$DC1.CATSUBV
>> SELECT FILENAME,PARTITIONNAME,CATALOGNAME
+> FROM \A.$DB1.CATSUBV.PARTNS;
FILENAME PARTITIONNAME CATALOGNAME
-------------- -------------- ---------------
\A.$DB1.SQL.T1 \A.$DA1.SQL.T1 \A.$DA1.CATSUBV
\A.$DB1.SQL.T1 \A.$DB1.SQL.T1 \A.$DB1.CATSUBV
\A.$DB1.SQL.T1 \C.$DC1.SQL.T1 \C.$DC1.CATSUBV
>> SELECT FILENAME,PARTITIONNAME,CATALOGNAME
+> FROM \C.$DC1.CATSUBV.PARTNS;