Since version 7.1 of DB2 for IBM i (aka iseries in ADS), it is possible to use predicates in INDEX in the form of a WHERE clause just after the...

read more