Character Partitioning directly on column (no CASE_N or RANGE_N defined)

Database
Enthusiast

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

1 REPLY
Senior Apprentice

Re: Character Partitioning directly on column (no CASE_N or RANGE_N defined)

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