' has conditions with both negative and positive constants.
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 generate limit low and high values from a greater-than-or-equals or greater-than negative constant and a less-than-or-equals or less-than positive constant. Range tests that include negative constants must not exceed -1.
Processing continues, but the skipped condition causes too many records to be read, which causes slower overall processing.
Construct two separate queries: one to process negative constants and one to process positive constants. This message can be suppressed using the REPORT_UNUSED_OPT_READING_CONDITIONS=N parameter.
ASK BOLOPreview
