' has a negative constant GE/GT condition without a LE/LT.
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 automatically generate a limit high value to match a less-than-or-equals, or a less-than condition that involves a negative constant.
Processing continues, but the skipped condition causes too many records to be read, which causes slower overall processing.
Correct the SQL WHERE clause to specify the low negative value with either the less-than (<) operator or the not-greater-than (<=) operator. This message can be suppressed using the REPORT_UNUSED_OPT_READING_CONDITIONS=N parameter.
ASK INFAPreview
