IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Getting -802 error when using MOD function in where clause


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Thu Sep 13, 2012 6:22 pm
Reply with quote

its fine Dick... Its a forum for discussing and sharing knowledge...

While seeing your comment... I felt, that I am wrong. icon_smile.gif
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Sep 14, 2012 1:27 pm
Reply with quote

When I said "If you examined", I meant the OP not dbz. Actually it's about the same as "had the TS used a CALL to DSNTIAR this would have been a non-issue."

The "BS" part was indeed a bit harsh, "off target" would have been better.

-802 is the error for (among others) OVERFLOW on an arithmetic operation done by DB2.
+304 is the warning for conversion while moving to a HV.
It's a fine line but I guess here it applies.

I didn't mean to be offensive to anyone, certainly not to long-time active forum members.
I have some issues In Real Life, my tolerance for stupidity has been reached so I'm taking my frustration to any error made. Sorry for that.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Sep 14, 2012 2:12 pm
Reply with quote

GuyC,
I was clearly out-of-bounds and sorta kidding about the stinging BS.

I am much more critical and insensitive than you will ever be.
you have always conducted yourself as a gentleman.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Calling an Open C library function in... CICS 1
No new posts DATE2 function SYNCSORT 15
Search our Forums:

Back to Top