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 when there are no characters preceding a wildcard character (% or *).
Processing continues, but the skipped condition causes too many records to be read, which causes slower overall processing.
If possible, construct the SQL WHERE clause condition in a manner that the optimized reading process can use. This message can be suppressed using the REPORT_UNUSED_OPT_READING_CONDITIONS=N parameter.
ASK BOLOPreview
