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. You can only use negative constants with signed numeric fields, such as NUM16, NUM32, NUM64, PACKED,and ZONED.