DB2 FOR LUW / DB2FORLUW / 970 - DB2

While inserting a row that has double column, insert may fail 
with CLI0112E: Error in assignment, if in CLI application double 
column was bound as 
Varchar, even though the inserted value is within the double 
range. 
 
Steps to reproduce the error: 
 
create table abcd ( col1 int, col2 int, col3 double precision); 
 
--- 
opt echo on 
opt callerror on 
sqlallocenv 1 
sqlallocconnect 1 1 
sqldriverconnect  1 0 "DSN=sample;uid=xxx;pwd=****;" -3 200 
SQL_DRIVER_NOPROMPT 
sqlallocstmt 1 1 
getmem 1 1 SQL_C_LONG 
getmem 1 2 SQL_C_LONG 
getmem 1 3 SQL_C_CHAR 500 
updatemem 1 SQL_C_LONG value 23 
updatemem 2 SQL_C_LONG value 45 
updatemem 3 SQL_C_CHAR value 307 
"-0.000000000000000000000000000000000000000000000000000000000000 
0000000000000000000000000000000000000000000000000000000000000000 
0000000000000000000000000000000000000000000000000000000000000000 
0000000000000000000000000000000000000000000000000000000000000000 
000000000000000000000000000000000000000440935284694" 
sqlprepare 1 "insert into abcd values (?,?,?)" -3 
sqlbindparameter 1 1 SQL_PARAM_INPUT SQL_C_LONG SQL_INTEGER 0 0 
1 
sqlbindparameter 1 2 SQL_PARAM_INPUT SQL_C_LONG SQL_INTEGER 0 0 
2 
sqlbindparameter 1 3 SQL_PARAM_INPUT SQL_C_CHAR SQL_VARCHAR 0 0 
3 
sqlexecute 1 
sqltransact 1 1 SQL_COMMIT 
killenv 1

**************************************************************** 
* USERS AFFECTED:                                              * 
* CLI application Users                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP10 or higher                           * 
****************************************************************

First fixed in DB2 V9.7 FP10

keiner bekannt / siehe Local-Fix

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

15.05.2014
24.11.2014
24.11.2014

9.7.FP10