I am trying to get data from DB2 database using iSeries ODBC Access Driver and I am getting required data and working fine, but I am facing a problem in getting exact double value i.e. For Ex. DB Column is having value as 10.12 but my recordset always returns 10. I looked into the OriginalValue and UnderLyingValue properties of the field but both are having 10 not 10.12. Even the data type in the record set field is showing as adNumeric.
I am using this connection string:
Please help me here on how I can access the exact value as 10.12. Even I have tried the IMEX property with values 0, 1 and 2 as part of my connection string but no luck.