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 IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
No new posts Speed-up/reduce CPU use of code prino PL/I & Assembler 0 Tue Sep 26, 2017 12:05 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm

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