DB2 FOR LUW / DB2FORLUW / 970 - DB2

Under rare circumstances, an SQL statement that satisfies all of
the following conditions may return more rows than expected:
(1) the query has a join between a table and a correlated
subquery that returns non-deterministic results (e.g. FFNR
clause without an ORDER BY clause, a non-deterministic function)
(2) the query has an EXISTS predicate

****************************************************************
* USERS AFFECTED:                                              *
* All                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description and use Local Fix, or upgrade to       *
* release and fixpak that has this fix.                        *
****************************************************************
* RECOMMENDATION:                                              *
* See Error Description and use Local Fix, or upgrade to       *
* release and fixpak that has this fix.                        *
****************************************************************

Modify the correlated subquery to return deterministic results

not known / see Local fix

forerunner  : IT17787 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

03.11.2016
30.05.2017
30.05.2017