MQSeries.net :: View topic - problem with float values in the esql

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 » problem with float values in the esql

problem with float values in the esql

« View previous topic :: View next topic »

Author

Message

sachinramesh

Posted: Thu May 29, 2008 2:36 am Post subject: problem with float values in the esql

Disciple

Joined: 20 Feb 2007
Posts: 170

Hi

I am having an esql code which is doing a simple division

when i checked the code in debugging it is dividing the values

-2579250.20 with 2 and
giving the result -1289625.1

But while inserting the same value in the database it is inserting as
-1.289625E+6 and is throwing an error

ERROR: [IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003

The datatype of the variable is declared as float

and in the database the field is a decimal datatype and of length 8 .

Why is it happening like that.

Gaya3

Posted: Thu May 29, 2008 2:44 am Post subject:

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

length 8 is very less, increase it and test it once again.

Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die

sachinramesh

Posted: Thu May 29, 2008 3:13 am Post subject:

Disciple

Joined: 20 Feb 2007
Posts: 170

Gaya3 wrote:

length 8 is very less, increase it and test it once again.

Regards
Gayathri

Thanks Gayatri its working fine now

mgk

Posted: Thu May 29, 2008 3:42 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

Quote:

The datatype of the variable is declared as float
and in the database the field is a decimal datatype and of length 8 .

Why use a float in ESQL if the data in the DB is decimal? If will be more accurate to use decimal in ESQL as well.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

sachinramesh

Posted: Thu May 29, 2008 4:12 am Post subject:

Disciple

Joined: 20 Feb 2007
Posts: 170

mgk wrote:

Quote:

The datatype of the variable is declared as float
and in the database the field is a decimal datatype and of length 8 .

Why use a float in ESQL if the data in the DB is decimal? If will be more accurate to use decimal in ESQL as well.

hi mgk

Thanks for your suggestion i changed it to decimal and now it is workng perfectly...
Before(after changing the cloumn lenght to 15) it was inserting the value as-1289625.0000 instead of -1289625.1

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » problem with float values in the 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