lots of the tables in our database are partition by YR. The create table syntax is like :
Unique primary index (YR, ....)
partition by YR;
the constraint check under the dbc.indexconstraints is: CHECK ((YR) BETWEEN 1 AND 65535)
Is this a range_n partition or case_n partition?
Neither RANGE_N nor CASE_N. it's simply directly partitioned by YR.
Of course if YR means "year" you probably don't have a business which covers 65000 year, better use the correct range:
RANGE_N(YR between 1990 AND 2020 each 1)