Hi,

I am using .NET ODBC to connect to a DB2 (7.2) database and I have
strange problems when I SELECT or INSERT/UPDATE a field with a DECIMAL
datatype.

SELECT:
I have a decimal value 0.01 and the query returns 1.00. I then set
the PATCH2=15 option in my db2cli.ini and it started to work.

INSERT/UPDATE:
Every time I try and write to a field of type decimal I get the following
error (regardless of whether I use PATCH2=15):

[22005] [IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005

I explicitly set the parameters's datatype to decimal.

Has anyone experienced this before?

Thanks,

Matej