DB2 FOR LUW / DB2FORLUW / 970 - DB2

If a routine uses the same variable for both the IN and OUT 
parameters, the OUT may be NULL when the routine is called after 
it has been rebound.  The following is an example of a call to a 
routine that is using the parameters in this way. 
 
call proc1(myvar, myvar)

**************************************************************** 
* USERS AFFECTED:                                              * 
* SQL Routine users                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the DB2 LUW server to version 9.7 Fix Pack 9         * 
****************************************************************

The issue will not occur if an INOUT parameter is used. 
Variables that will be both passing (IN) data and receiving data 
(OUT) can be declared as INOUT rather than passing in the 
variable twice. For example if the procedure was called as 
proc1(myvar, myvar), it can be called as proc1(myvar) if an 
INOUT rather than an IN and OUT parameter is used. 
 
For additional information on the INOUT parameter please see the 
Create procedure statement at the following Infocenter page. 
 
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2 
Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0003493.html

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
 

The fix is applied to the server and was first fixed in version 
9.7 Fix Pack 9

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC96967 IC96973 
follow-up : 

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

19.09.2013
18.12.2013
18.12.2013

9.7.FP9