DB2 List / Range Partition

This is a discussion on DB2 List / Range Partition within the db2-udb forums in Other Databases category; We are planning to partition a table on List basis like Below is syntax of List Partitioning in Oracle: create table myTable(T_ID int Primary key, T_Status char, T_Date date, ...) partition by List(T_Status) ( partition p1 values('A'), partition p2 values('B'), partition p3 values('C'), partition p_else (Default) ); We tried to get same in DB2 as partition by Range(T_Status) ( partition starting ('A') ending ('A'), partition starting ('B') ending ('B'), partition starting ('C') ending ('C'), partition p_else (Default)...

Go Back   Database Forum > Other Databases > db2-udb

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 05-06-2008, 07:09 AM
Default DB2 List / Range Partition

We are planning to partition a table on List basis like

Below is syntax of "List Partitioning" in Oracle:

create table myTable(T_ID int Primary key, T_Status char, T_Date date, ...)
partition by List(T_Status)
(
partition p1 values('A'),
partition p2 values('B'),
partition p3 values('C'),
partition p_else (Default)
);


We tried to get same in DB2 as
partition by Range(T_Status)
(
partition starting ('A') ending ('A'),
partition starting ('B') ending ('B'),
partition starting ('C') ending ('C'),
partition p_else (Default) <== Here we get error, we need all status values in this partition other than 'A','B','C'
);

Can we partition the table on both T_Status (A character field) and T_Date(A date field) like
Partition by Range(T_Status, T_Date)
(
....
)


regards
Kamran
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 10:02 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.