DB2 FOR LUW / DB2FORLUW / 970 - DB2

When the input parameters of an inlined SQL scalar UDF contains
an OLAP specification, and under any of the following
situations, wrong results are possible.

(1) When such UDF appears in select clause, and the select
clause also has "distinct" keyword.
(2) When such UDF appears in order by clause

You can work around the issue by modifying the query. For
example, if the query is:

select C2
from T1
order by F1(min(C1) over (partition by C2))

You can modify the query to:

select C2
from
(
select C2, F1(min(C1) over (partition by C2)) as CC
from T1
)
order by CC

If the query is

select distinct F1(min(C1) over (partition by c2)) *
F1(count(C1) over (partition by c2))
from T1

You can modify the query to:

select distinct F1(CC1) * F1(CC2)
from
(
select min(C1) over (partition by c2) as CC1, count(C1) over
(partition by c2) as CC2
from T1
)

****************************************************************
* USERS AFFECTED:                                              *
* All                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description and modify the query, or upgrade to    *
* the release and fixpak that has this fix.                    *
****************************************************************
* RECOMMENDATION:                                              *
* See Error Description and modify the query, or upgrade to    *
* the release and fixpak that has this fix.                    *
****************************************************************

Modify the query; see "Error Description"

not known / see Local fix

forerunner  : IT17941 
follow-up : 

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

14.11.2016
30.05.2017
30.05.2017