DB2 FOR LUW / DB2FORLUW / 970 - DB2

When calling a stored procedure located on a non 
Linux/Unix/Windows database 
server such as z/OS and i-Series the return code inside the 
stored procedure is not returned. 
 
The output below should return "RETURN STATUS: 1000" since this 
was coded in the stored procedure.  Instead the incorrect output 
"RETURN STATUS: 0" is returned. 
 
 
connect to sample user db2inst1 using 
 
   Database Connection Information 
 
 Database server        = DB2 z/OS 9.1.5 
 SQL authorization ID   = DB2INST1 
 Local database alias   = SAMPLE 
 
 
CREATE PROCEDURE TEST (OUT ID INTEGER) RESULT SETS 1 
        LANGUAGE SQL 
        DISABLE DEBUG MODE 
P1: BEGIN 
 
        DECLARE cursor1 CURSOR WITH RETURN FOR SELECT c1 from 
t1; 
        -- If OPEN cursor1 is commented out the expected rc=1000 
is returned 
        OPEN cursor1; 
        RETURN 1000; 
END P1 
DB20000I  The SQL command completed successfully. 
 
call test(?) 
ID: NULL 
 
C1 
 
 "TEST" RETURN_STATUS: 0

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 version 9.7 Fixpack 7.                             * 
****************************************************************

DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem first fixed in DB2 version 9.7 Fixpack 7.  This should 
be applied to the DB2 Connect system used to establish 
connectivity to non Linux/Unix/Windows database servers such as 
z-Series and i-Series.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC88341 
Nachfolger : 

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

12.07.2012
30.10.2012
30.10.2012

9.7.FP7