ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportHandling Float Data in ESQL

Post new topicReply to topic
Handling Float Data in ESQL View previous topic :: View next topic
Author Message
syedimtiyaz1234
PostPosted: Wed Feb 10, 2021 1:15 pm Post subject: Handling Float Data in ESQL Reply with quote

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
Back to top
View user's profile Send private message
timber
PostPosted: Wed Feb 10, 2021 1:40 pm Post subject: Reply with quote

Grand Master

Joined: 25 Aug 2015
Posts: 1174

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.
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportHandling Float Data in ESQL
Jump to:



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
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.