Although unwieldy, this does correctly match the predicate on the server and return the expected value.
It is useful when a table has a finite set of values for the fragment key (or partitioning key) and queries on the table have an equality predicate on the fragment key.
DB2 can use an index defined on a single relational column to answer any equality or range predicate on this column.