Nonstop Database, HiRDB Version 9 System Operation Guide
Using CHANGE RDAREA of ALTER TABLE, change the partitioning storage conditions. You cannot perform partitioning and combining simultaneously. To perform partitioning and combining, execute ALTER TABLE twice. In the case of matrix partitioning, you can change only key range partitioning dimensions that use boundary value specification.
This is the state before the partitioning storage conditions are combined or partitioned.
CREATE FIX TABLE "USERA"."STOCK" ("GNO" CHAR(5),"GNAME" CHAR(8),"STD" CHAR(3),"UNTPRC" INTEGER,"RCVD_DATE" CHAR(10)) PARTITIONED BY MULTIDIM ("GNO"(('20000')),"RCVD_DATE" (('2000-12-31'),('2001-12-31') ,('2002-12-31'))) IN (("RDAT01","RDAT02","RDAT03","RDAT04"),("RDAT11","RDAT12","RDAT13","RDAT14")) CLUSTER KEY ("GNO","RCVD_DATE") IN (("RDAI01","RDAI02","RDAI03","RDAI04"),("RDAI11","RDAI12","RDAI13","RDAI14")) |
In the second dimension partitioning column RCVD_DATE, years through 2000 and years through 2001 are combined into years through 2001.
ALTER TABLE "USERA"."STOCK" CHANGE RDAREA MULTIDIM ("RCVD_DATE" (('2000-12-31'),('2001-12-31'))) AT (('2001-12-31')) INTO (("RDAT02"),("RDAT12")) FOR CLUSTER KEY INTO (("RDAI02"),("RDAI12")) |
In the second dimension partitioning column RCVD_DATE, Other is partitioned into years through 2003 and Other.
ALTER TABLE "USERA"."STOCK" CHANGE RDAREA MULTIDIM ("RCVD_DATE" ((MAX))) AT (('2003-12-31'),(MAX)) INTO (("RDAT04","RDAT01"),("RDAT14","RDAT11")) FOR CLUSTER KEY INTO (("RDAI04","RDAI01"),("RDAI14","RDAI11")) |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.