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 How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 0 Thu Jan 12, 2017 12:02 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm


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