|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Tutorialized Forums Sponsor:
|
|
#1
May 6th, 2008, 04:57 AM
|
|||
|
|||
|
DB2 List / Range Partitioning
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
|
|
| Viewing: Tutorialized Forums > Databases > DB2 > DB2 List / Range Partitioning |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
