0 - 3 of 3 tags for COLUMN PARTITION

Hi all,

I have a question about partition of a table.

 

I have a table with a unique primary index column1 of datatype char(2).

I want to define a RANGE_N - partition on column1 using the hash-function HASHROW as follow:

 

col1          col2 col3   col 4   calculatedcolumn
201301      1      ?      ?           ?
201302       1    ?       ?           ?
201303       1   4.5      3        4.5*12+3(col4) so my value is 57
201304       1    ?        2            57*12+2           686  

Hi Experts,