All Forums Database
lokmac 8 posts Joined 08/09
04 Oct 2011
Character Partitioning directly on column (no CASE_N or RANGE_N defined)

Hi,

Is there any way to partition directly on a small (ie. CHAR(3)) character column, without defining a CASE_N or RANGE_N for the column (ie. partition on all unique values of the column)?

I have found that I can create a table with the partition defined on such a column, but when I go to INSERT data into the table I get "INSERT Failed.  [5728] Partitioning violation for table".

We're running TD 13.10.

Thanks

dnoeth 4628 posts Joined 11/04
04 Oct 2011

It would be easier when you showed the CREATE you tried :-)

I don't think you can do that without RANGE_N (even on 13.10).

This comes close, but will only work for any access using "col=value":
range_n(hashbucket(hashrow(col)) between 0 and 65535 each 1

Dieter

Dieter

You must sign in to leave a comment.