DB2 FOR LUW / DB2FORLUW / A10 - DB2

When INNER JOIN operation is referenced outside of FROM clause, 
db2 returns SQL0901N error message and generates dump files. For 
example: 
 
   with 
      test1  as (  select 1 as c1    from sysibm.sysdummy1  ) , 
      test1_recur  ( c1 )  as  ( 
        select c1  from test1 
        union all 
          (select c1+1 from test1_recur  where c1 < 10 )  as c1 
          inner join 
          (  select 3 as c3  from sysibm.sysdummy1  ) as c3 
          on 1=1   and c3.c3 = c1.c1  ) 
   select * from test1_recur; 
 
This example query is not syntaticaly correct. The INNER JOIN 
operation can only be referenced in the FROM clause of a 
subselect. 
 
When this query is executed, db2 returns SQL0901N error and 
generates dump files.  This APAR will return more graceful error 
instead of the SQL0901N, which will not generate dump files.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 FP1 or subsequent fix pack               * 
****************************************************************

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First Fixed in DB2 Version 10.1 Fix Pack 1

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

12.06.2012
03.01.2013
03.01.2013