IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50

A prepared statement inserting a DECIMAL value omits the digits 
after the decimal point when statement cache is on and the 
statement is executed the second time. 
 
This reproduces for DRDA clients only (Data Server Driver for 
JDBC or .NET). 
 
Example using Data Server Driver for JDBC 
 
PreparedStatement pstmt2=conn.prepareStatement("insert into 
instab1 values(?,?)"); 
 
int vid = 1; 
BigDecimal vc1 = new BigDecimal(88.88); 
 
pstmt2.setInt(1,vid); 
pstmt2.setBigDecimal(2,vc1); 
pstmt2.executeUpdate(); 
 
With STMT_CACHE_HITS 0 
 
After first execution; 
 
Select from instab 
id = 1 c1 = 88.88 
 
After subsequent executions: 
 
Select from instab 
id = 1 c1 = 88.00

**************************************************************** 
* USERS AFFECTED:                                              * 
* DRDA clients with decimal data types                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A prepared statement inserting a DECIMAL value omits the     * 
* digits after the decimal point when statement cache is on    * 
* and the statement is executed the second time.               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to IDS 11.50.xC5 and above.                          * 
****************************************************************

Problem first fixed in IDS 11.50.xC5.

not known / see Local fix

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

25.06.2009
22.01.2010
22.01.2010

11.50.xC5