' has a condition with an unacceptable negative constant.
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 use negative constants on equals conditions, and sometimes for GE/GT,LE/LT conditions on the primary key column. The availability of negative constants depends on the source database. This message indicates that the negative constant could not be processed.
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 using comparisons on fields that are used in a database key. This message can be suppressed using the REPORT_UNUSED_OPT_READING_CONDITIONS=N parameter.
ASK INFAPreview
