DB2 FOR LUW / DB2FORLUW / 970 - DB2

The following example shows a table that has a value of 5.6 
inserted into a NUMBER column 
create table test(a number(10)) ; 
insert into temp values (5.6) ; 
 
When using DB2CI with SQLT_FLT in OCIBindByName/OCIBindByPos 
calls, the number will be returned as 5 instead of 5.6 as the 
number was truncated instead of rounded to 6 as seen from 
CLPPLUS.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW v9.7                                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2CI using SQLT_FLT in OCIBindByName/OCIBindByPos calls on  * 
* NUMBER columns get truncated values instead of being rounded * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v9.7 Fixapack 4                           * 
****************************************************************

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 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
 

First fixed in DB2 LUW v9.7 Fixapack 4

keiner bekannt / siehe Local-Fix

Requirement

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

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

01.12.2010
17.08.2011
17.08.2011

9.7.