View previous topic :: View next topic
|
Author |
Message |
prateek_nanda
New User
Joined: 13 Jul 2007 Posts: 19 Location: Gurgaon
|
|
|
|
Hi ,
I am getting 802 for one of my Queries below is the error msg
SQLCODE = 802, WARNING: EXCEPTION ERROR OUT OF RANGE HAS OCCURRED
DURING LN OPERATION ON FLOAT DATA, POSITION ...
I am trying to multiply column values using LOG logic
EXP((SUM(CAST(LN(ABS(TOT_RET_CALC))AS DOUBLE))))
Tried to cast it in Double float etc. nothing worked.
if anyone could suggest me something on this??
Thanks!! |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Prateek,
What is the value you are passing to TOT_RET_...... variable? |
|
Back to top |
|
|
prateek_nanda
New User
Joined: 13 Jul 2007 Posts: 19 Location: Gurgaon
|
|
|
|
Hi Mulali,
It is getting pulled from a table column. ( decimal 9,2)
Thanks!! |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
By anychance the column contains '0'?
Code: |
SELECT EXP((SUM(CAST(LN(ABS(0000000.00))AS DOUBLE)))) 000
FROM SYSIBM.SYSDUMMY1; 000
---------+---------+---------+---------+---------+---------+---------+-----
---------+---------+---------+---------+---------+---------+---------+-----
???????????????????????
DSNT404I SQLCODE = 802, WARNING: EXCEPTION ERROR OUT OF RANGE HAS OCCURRED
DURING LN OPERATION ON FLOAT DATA, POSITION
DSNT418I SQLSTATE = 01519 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRLE SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 1131 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION |
Code: |
SELECT EXP((SUM(CAST(LN(ABS(0000000.01))AS DOUBLE))))
FROM SYSIBM.SYSDUMMY1;
---------+---------+---------+---------+---------+---------+-----
---------+---------+---------+---------+---------+---------+-----
+0.1000000000000000E-01
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100 |
|
|
Back to top |
|
|
prateek_nanda
New User
Joined: 13 Jul 2007 Posts: 19 Location: Gurgaon
|
|
|
|
Hi Murali,
I checked the data .There are no Zeros . Actualy is is giving problems at the time of SUM . I removed that sum part and ran the query ,it gave me good results but my requirment is to add them in the end.
Thanks for replying back.
Prateek |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Prateek,
Quote: |
DURING LN OPERATION ON FLOAT DATA, POSITION ... |
Quote: |
Actualy is is giving problems at the time of SUM |
Your expression worked fine for me. Try verifying one more time. |
|
Back to top |
|
|
prateek_nanda
New User
Joined: 13 Jul 2007 Posts: 19 Location: Gurgaon
|
|
|
|
Murali,
I checked it .I ran the query without SUM function and it ran fine but as and when I am putting sum function it is giving me same error saying
DURING LN OPERATION ON FLOAT DATA, POSITION
Thanks!! |
|
Back to top |
|
|
|