DB2 EXP() command returning arithmetic overflow

Question

Hi I am using the EXP() command in DB2 on a column of type float as so

select distinct 1 - power(0.9144,exp(beta - 0.1)) from mytable

where this all works fine until I introduce the exp() around (beta - 0.1). beta is a float and ranges between 3018.878989897931 and 12289.951602012534.

the error I am getting is

Arithmetic overflow or other arithmetic exception occurred.. SQLCODE=-802,SQLSTATE=22003,DRIVER=3.64.106

what could be the issue here?

mustaccio · Accepted Answer · 2014-05-13 14:57:56Z

1

Obviously, the issue here is your exceeding the maximum range representable by a 64-bit floating point number format, which is about +1.79769E+308.

If you do need to work with larger numbers, consider performing calculations in DECFLOAT(34) instead (if your DB2 version supports this data type).

answered May 13, 2014 at 14:57

mustaccio

19.1k16 gold badges51 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DB2 EXP() command returning arithmetic overflow

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related