Da scheint das bei V7R2 ja wohl behoben zu sein. Mal sehen, wann es das PTF dann für V7R1 gibt.

Ich habe nun noch mal das Ankündigungsschreiben für V6R1 analysiert:

3.11.24 SQL Query changes in collation of errors might result in a

SQL0802

In PTF MF45590, a change was made to not collate errors for SQL queries

with distinct or aggregation. This was done to avoid providing wrong

results when a result in error can not be included in aggregation or

distinct result sets. A selection error is now signalled in this

scenario, using the SQL0802 message with SQLCODE=-802 and

SQLSTATE='22003'. The SQL0802 message will be preceded by CPF5035 and

CPD4019 escape messages.

To allow compatibility with previous behavior, a new QAQQINI option,

COLLATE_ERRORS, is available by PTF.

COLLATE_ERRORS - Specifies how data errors are handled on the GROUP BY

and ORDER BY expression during hash or sort processing within queries.

Supported values:

* *DEFAULT - The default is *NO.

* *NO - A value of *NO causes the query to be ended with an error when

a grouping or ordering expression results in an error.

* *YES - A value of *YES indicates that the grouping or sort continues.

Da steht nichts davon das SQL0802 nun positiv gesetzt wird oder verstehe ich da was falsch?