To change the partitioning storage conditions, specify CHANGE RDAREA in the ALTER TABLE statement. Splitting and combining cannot be executed at the same time. To execute both splitting and combining, use two separate ALTER TABLE statements.
The following shows an example of partitioning storage conditions before combining or splitting:
CREATE FIX TABLE "T1"("C1" CHAR(10),"C2"... |
The following example combines data from the Berkeley and Oakland branches into the same RDAREA:
ALTER TABLE "T1" CHANGE RDAREA PARTITIONED CONDITION (("TA1"),("TA2")) INTO ("TA1") |
The following example splits the data for the San Francisco and San Jose branches into separate RDAREAs:
ALTER TABLE "T1" CHANGE RDAREA PARTITIONED CONDITION |