|
Problem IC85877
|
Status: Closed |
SQL COMPATIBILITY : EXIT COMMAND DOES NOT RETURN PROPER RETURN CODE FOR BIND VARIABLES WITH NUMBER DATATYPE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* 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. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
v97 FP7 fixes this issue. User will be able to use bind
variables of type NUMBER with EXIT command. |
| Workaround |
Use integer bind variable instead |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC88638
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.08.2012
20.10.2012
20.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
