Hi, I'm Bolo!
What would you like to know?
ASK BOLOPreview
Please to access Bolo.

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- 03009

PWX-
03009

SELECT DISTINCT not guaranteed with Expressions
SQL containing “select distinct” was used, and some user defined fields (Expressions) requested. “Select distinct” should only be used with whole DB2 fields.
SQL containing “select distinct” is passed to DB2, but additional columns not seen by the user might be requested that result in apparent duplicate rows being returned.
Verify that “select distinct” is having a meaningful effect.

0 COMMENTS

We’d like to hear from you!