DB2 FOR LUW / DB2FORLUW / A50 - DB2

User might observe SQL0901 error when running a select statement
with the following characteristics:

1) The query calls a table function with an argument
2) The query is joining the result of the table function with
another table, and the joining column is passed to the table
function as an input argument.
3) The input argument is being referenced by the subquery inside
the table function.
4) The subquery inside the table function has outer joins.

****************************************************************
* USERS AFFECTED:                                              *
* All DB2 systems on all Linux, Unix and Windows platforms at  *
* service levels Version 10.5 GA through to Version 10.5 Fix   *
* Pack 10                                                      *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 Version 10.5 Fix Pack 11 or higher. See       *
* "Local Fix" portion for other suggestions.                   *
****************************************************************

Workaround:

Modify the join predicate between the table function and the
table like:

table_function.c1 = table.c1
->
table_function.c1 + 0 = table.c1 + 0

not known / see Local fix

forerunner  : 
follow-up : IT29337 

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

15.05.2019
28.06.2020
28.06.2020