This example creates a partitioned primary index based on character data specified for a RANGE_N function. Notice that no EACH clause is specified for the RANGE_N partitioning expression in level 1 of the multilevel partitioning in this case.
CREATE TABLE t1( i INTEGER, j CHARACTER(4), k INTEGER) PRIMARY INDEX(i) PARTITION BY (RANGE_N(j BETWEEN 'aaaa','cccc','eeee', 'gggg','iiii','kkkk', 'mmmm','oooo','qqqq', 'ssss' AND 'tttt', NO RANGE), RANGE_N(k BETWEEN 1 AND 10 EACH 1));