Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

802 SQL code: EXCEPTION ERROR OUT OF RANGE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
prateek_nanda

New User


Joined: 13 Jul 2007
Posts: 19
Location: Gurgaon

PostPosted: Mon Aug 11, 2008 10:52 am    Post subject: 802 SQL code: EXCEPTION ERROR OUT OF RANGE
Reply with quote

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
View user's profile Send private message

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Mon Aug 11, 2008 11:11 am    Post subject:
Reply with quote

Prateek,

What is the value you are passing to TOT_RET_...... variable?
Back to top
View user's profile Send private message
prateek_nanda

New User


Joined: 13 Jul 2007
Posts: 19
Location: Gurgaon

PostPosted: Mon Aug 11, 2008 12:14 pm    Post subject:
Reply with quote

Hi Mulali,

It is getting pulled from a table column. ( decimal 9,2)

Thanks!!
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Mon Aug 11, 2008 12:19 pm    Post subject:
Reply with quote

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
View user's profile Send private message
prateek_nanda

New User


Joined: 13 Jul 2007
Posts: 19
Location: Gurgaon

PostPosted: Mon Aug 11, 2008 1:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Mon Aug 11, 2008 1:14 pm    Post subject:
Reply with quote

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
View user's profile Send private message
prateek_nanda

New User


Joined: 13 Jul 2007
Posts: 19
Location: Gurgaon

PostPosted: Mon Aug 11, 2008 1:36 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us