Create partition table based upon substr of column
Posted: Thu Sep 02, 2010 10:46 pm
I have a need to create a 5 partitioned table where the limits of the partitions would be based upon the 5-7 positions of a char(10) defined column. I am limited to how the column names are defined...ie I need to keep the column defined as a char(10) and cannot split it. Is this possible?
I am running ZOS DB2 V9.
I am running ZOS DB2 V9.
CREATE TABLE owner.table
(ID CHAR(10) NOT NULL,
BUSINESS CHAR(04) NOT NULL,
RECORD CHAR(02) NOT NULL,
CONSTRAINT CONSTR1_PEND
PRIMARY KEY (
ID,
BUSINESS)
)
PARTITION BY RANGE (ID(5:3))
(PARTITION 1 ENDING AT ('099'),
PARTITION 2 ENDING AT ('199'),
PARTITION 3 ENDING AT ('299'),
PARTITION 4 ENDING AT ('399'),
PARTITION 5 ENDING AT ('499'))
IN POSSIBLE.STUFF;
(ID CHAR(10) NOT NULL,
BUSINESS CHAR(04) NOT NULL,
RECORD CHAR(02) NOT NULL,
CONSTRAINT CONSTR1_PEND
PRIMARY KEY (
ID,
BUSINESS)
)
PARTITION BY RANGE (ID(5:3))
(PARTITION 1 ENDING AT ('099'),
PARTITION 2 ENDING AT ('199'),
PARTITION 3 ENDING AT ('299'),
PARTITION 4 ENDING AT ('399'),
PARTITION 5 ENDING AT ('499'))
IN POSSIBLE.STUFF;