Posted: Wed Feb 10, 2021 1:15 pm Post subject: Handling Float Data in ESQL
Apprentice
Joined: 22 Jan 2018 Posts: 30
Hey,
Could you please provide some inputs, from our IIB ESQL we get the data from Oracle DB and the data type of that column is defined as Number.
so when we insert the data more that 16 digit , the data is inserted good in the DB.
But when we fetch the data, its getting as FLOAT with Exponential format and data is also not same.
so wanted to know is there any way we can have exact data retrived from Oracle DB. And when try to convert to integer the data is changed.
I also checked this link why the data is converted to Float and that makes sense but it is not coming as exact data.
https://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/ak05730_.htm
Please provide examples of the problem (actual values). If possible, use the output from a Trace node when you are talking about the values returned from the database.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum