Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 IBEGENER RETURN CODE 12 anilkumar922 All Other Mainframe Topics 5 Wed Dec 13, 2017 11:41 am
No new posts Finding the plan when code compiled u... Ahemad DB2 1 Fri Dec 01, 2017 6:38 pm
No new posts Strange Code amitc23 COBOL Programming 6 Tue Nov 28, 2017 11:25 am
No new posts Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us