DB2 FOR LUW / DB2FORLUW / 970 - DB2

This issue is critical in terms of customer's migrating from 
oracle to DB2 will need to modify their scripts, if they have 
bind variables of type NUMBER and used with EXIT command. 
 
CLPPlus EXIT command returns always 0 when used with Bind 
Variable of type NUMBER. for example: 
 
variable exit_value number; 
 
declare 
v_dummy integer; 
begin 
:exit_value:=9; 
select col01 into v_dummy from (select 1 col01  from dual); 
end; 
/ 
 
exit :exit_value

**************************************************************** 
* USERS AFFECTED:                                              * 
* Customers migrating from Oracle to DB2 will encounter this   * 
* issue if their SQL scripts have EXIT command with NUMBER     * 
* bind variable type                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v97 FP7 or later releases.                        * 
****************************************************************

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
 

v97 FP7 fixes this issue. User will be able to use bind 
variables of type NUMBER with EXIT command.

Use integer bind variable instead

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

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

14.08.2012
20.10.2012
20.10.2012

9.7.FP7