Table of Contents

Search

  1. Preface
  2. PWX-00000 to PWX-00099
  3. PWX-00100 to PWX-00999
  4. PWX-01000 to PWX-01999
  5. PWX-02000 to PWX-04999
  6. PWX-05000 to PWX-06999
  7. PWX-07000 to PWX-09999
  8. Abend, Return, and Reason Codes in PowerExchange Messages

Message Reference Volume 1

Message Reference Volume 1

PWX-03083

PWX-
03083

Condition skipped. Table '
table_name
' column '
column_name
' Constant is a float or double.
When PowerExchange executed SQL with a WHERE clause against data for Adabas, the optimized reading process discarded a condition .The condition is still used for post-read qualification. PowerExchange cannot produce limit low and high values for a scalar field for which the field's scale does not match the number of digits after the decimal point in the constant.
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. Database keys do not typically contain float or double fields. This message can be suppressed using the REPORT_UNUSED_OPT_READING_CONDITIONS=N parameter.

0 COMMENTS

We’d like to hear from you!
Hi, I'm Bolo!
What would you like to know?
Please to access Bolo.