| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| 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 |
![]() |
| Thread Tools | |
| Display Modes | |