MQSeries.net :: View topic - Precision lost on select from remote db

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 » Precision lost on select from remote db

This topic is locked: you cannot edit posts or make replies.

Precision lost on select from remote db

« View previous topic :: View next topic »

Author

Message

sat_in_field

Posted: Tue Nov 16, 2004 8:12 am Post subject: Precision lost on select from remote db

Novice

Joined: 23 Jan 2003
Posts: 20

Hi,

Using wmqi 2.1 I am selecting number(17,3) from an oracle db and I am loosing precision.
value selected 12345678901234.567

value returned to FLOAT variable 123456789012345E+13
result after cast to char is 12345678901234.500

value returned to DECIMAL 12345678901234.500 after (implicit conversion)
resulting after cast to char is 12345678901234.500

Any help would be greatly appreciated.

Thanks
Steve

kirani

Posted: Tue Nov 16, 2004 9:30 am Post subject:

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA

Please post WMQI related questions into WMQI Forum.
[Moving to WMQI Forum]
_________________
Kiran

IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Precision lost on select from remote db

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