| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Controlling the format of FLOAT cast as CHAR |
« View previous topic :: View next topic » |
| Author |
Message
|
| KevinCampbell |
 Posted: Thu Feb 06, 2003 7:34 am Post subject: Controlling the format of FLOAT cast as CHAR |
 |
|
Newbie
Joined: 06 Feb 2003
Posts: 2
Location: Seattle, WA
|
MQSI 2.02
I'm building an XML output message and need to set a value based on the result of dividing two floats. Since all XML elements are essentially string data, the number is implicitly being CAST to a CHAR.
When using CAST() the numeric representation of small numbers is in exponential format, as the manual describes.
0.55 becomes 5.5E-1
Does anyone know of a way to control this formatting behaviour? Ideally I would like to be able to specify a format template to be used when creating the CHAR representation of the float.
Kevin |
|
| Back to top |
|
 |
| yaakovd |
| Posted: Thu Feb 06, 2003 8:58 am Post subject: |
|
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
Do you have any problem using DECIMAL format?
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel |
|
| Back to top |
|
|
| KevinCampbell |
| Posted: Thu Feb 06, 2003 11:06 am Post subject: Other than.. |
|
|
Newbie
Joined: 06 Feb 2003
Posts: 2
Location: Seattle, WA
|
It hadn't occurred to me!
Thanks for the suggestion, I think that decimal will probably do just fine. I had not looked that deeply into the difference between the two types.
Kevin |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
