DB2 FOR LUW / DB2FORLUW / A50 - DB2

Queries that reference to columns from the objects at the same
level of the FROM clause
using the keyword TABLE in combination with the usage of LEFT
OUTER JOIN keyword
such as the example below:

SELECT
  ...
FROM
  table_1
  LEFT OUTER JOIN
  table_2
  ON 
  LEFT OUTER JOIN
  TABLE (SELECT
           ...
         FROM
           table_3
         WHERE
           [reference to table_2.columns]
        )
  ON 
...

The references to columns from table_2 which are the right
operand of the LEFT OUTER JOIN prior to the keyword TABLE
may cause "SQL0901N Empty plan list detected".

The keyword LATERAL is a synonym of TABLE.

RIGHT OUTER JOIN may cause the same problem when the references
is to the left operand of the RIGHT OUTER JOIN.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Rewrite the query such that it uses a different plan.        *
****************************************************************

Rewrite the query to avoid this issue.

not known / see Local fix

forerunner  : 
follow-up : IT23350 

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

30.11.2017
08.01.2018
08.01.2018