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.  Partitioning violation for table".
We're running TD 13.10.
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