DB2 FOR LUW / DB2FORLUW / A10 - DB2

SQL20454N error will be returned if a package is compiled which 
contains an outer join operator specified as "(+)" used in a 
cursor definition. For example the following package fails to 
compile: 
 
SET SQLCOMPAT PLSQL; 
 
create table T1(fk1 integer, fk2 integer); 
create table T2(pk1 integer, pk2 integer); 
 
drop package broken; 
 
create or replace package broken as 
cursor c1(v_pk1 in T2.pk1%TYPE) 
is 
  select * from T1, T2 
    where T1.fk1(+) = v_pk1 
      and T1.fk1(+) = T2.pk2; 
 
end broken; 
/

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 4.                      * 
****************************************************************

DB2 Version 10.1 Fix Pack 4 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 4.

not known / see Local fix

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

11.07.2013
23.06.2014
23.06.2014