iSeries ODBC Access Driver - Get exact Double value as it is

Hello All,

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: https://www.connectionstrings.com/ibm-iseries-access-odbc-driver/standard/

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.

0
edit delete
are you sure?
asked Shanmugavel Chinnagounder

0 answers

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions