DB2 FOR LUW / DB2FORLUW / A50 - 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:                                              * 
* All SQL Routine Users                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) or higher. as soon as possible.                      * 
****************************************************************

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 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 Fixed in Version 10.5 in DB2 Cancun Release 10.5.0.4 (also 
known as Fix Pack 4) Fix Pack 4.

not known / see Local fix

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

17.10.2013
15.09.2014
16.10.2014