DB2 FOR LUW / DB2FORLUW / A50 - DB2

The following examples display the behavior.   Please note that 
this change was only shipped in DB2 10.5 Fixpack 4.  This change 
is being rolled back to previous behavior via APAR IT04141 
 
 
CREATE OR REPLACE FUNCTION R1.F1() 
SPECIFIC F1 
RETURNS INT 
RETURN 1 
DB20000I  The SQL command completed successfully. 
 
CREATE OR REPLACE FUNCTION R1.F2 ( ) 
RETURNS INTEGER 
SOURCE R1.F1() 
DB20000I  The SQL command completed successfully. 
 
CREATE OR REPLACE MODULE R1.M1 
DB20000I  The SQL command completed successfully. 
 
ALTER MODULE R1.M1 
PUBLISH FUNCTION F1() 
SPECIFIC F1 
RETURNS INT 
RETURN 1 
DB20000I  The SQL command completed successfully. 
 
CREATE OR REPLACE FUNCTION R1.F2M ( ) 
RETURNS INTEGER 
SOURCE R1.M1.F1() 
DB20000I  The SQL command completed successfully. 
 
SELECT SUBSTR(ROUTINESCHEMA,1,5), SUBSTR(ROUTINENAME,1,5), 
SUBSTR(IMPLEMENTATION,1,10) FROM SYSCAT.ROUTINES WHERE 
ROUTINESCHEMA = 'R1' AND ROUTINENAME IN ('F2', 'F2M') 
 
1     2     3 
----- ----- ---------- 
R1    F2    R1.F1 () 
R1    F2M   R1.F1 () 
 
  2 record(s) selected. 
 
The second row should ready R1.M1.F1() for the IMPLEMENTATION.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First changed in DB2 10.5 Fixpack 4 but this change is being * 
* rolled back to previous behavior via APAR IT04141            * 
****************************************************************

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First changed in DB2 10.5 Fixpack 4 but this change is being 
rolled back to previous behavior via APAR IT04141

not known / see Local fix

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

30.09.2013
02.09.2014
02.09.2014