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 can't compare one column's value to another column's value. It can only compare a column value against a constant or a substitution marker (?) when look-ups are used.
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 INFAPreview
