MQSeries.net :: View topic - exponential value to float

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » exponential value to float

exponential value to float

« View previous topic :: View next topic »

Author

Message

pyrus

Posted: Thu Aug 16, 2007 1:29 am Post subject: exponential value to float

Novice

Joined: 20 Jul 2007
Posts: 16
Location: Belgium

Hi,

I have an incoming xml message which contains some exponential values (e.g. 7.535110000000000e+005). I found a function EXP() which gives an exponential value for any numeric value). I need this function the other way around, I'm afraid I will have to write a function myself.

I think it should exist because it's kind of stupid to have the conversion only in one direction.

Simple casting won't do, I just keep the exponential notation....

Thanks

shalabh1976

Posted: Thu Aug 16, 2007 9:56 pm Post subject:

Partisan

Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India

You can try a cast to a decimal.
Please be aware that if you only want a certain number of valuesafter the decimal you may have play around a bit with precision & scale. A trim leading zero might also be required.
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » exponential value to float

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