When PowerExchange executed SQL with a WHERE clause against data for Adabas, Datacom, IDMS, IMS or KSDS, the NRDB optimized reading process discarded a condition .The condition is still used for post-read qualification. PowerExchange cannot produce limit low and high values for field types that do not have defined rules, such as the following types:

Variable Length fields (VARBIN, VARCHAR, BLOB, CLOB)
Fields requiring reformatting (TIME, TIMESTAMP)