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

What's the Diff +and - Sql Codes


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

New User


Joined: 24 Dec 2003
Posts: 1

PostPosted: Wed Dec 24, 2003 12:10 pm
Reply with quote

Hi,
Can U just Tell me What's the Diff betwee Sql Code + and -

Gr
Back to top
View user's profile Send private message
krbabu

New User


Joined: 20 Feb 2004
Posts: 57

PostPosted: Fri Feb 20, 2004 2:48 pm
Reply with quote

hI ginind,
i think in db2 error + indicate sthe error messages while as - indicates the warning messages.
Back to top
View user's profile Send private message
raak

Active User


Joined: 23 May 2006
Posts: 166
Location: chennai

PostPosted: Fri Nov 09, 2007 9:54 am
Reply with quote

krbabu wrote:
hI ginind,
i think in db2 error + indicate sthe error messages while as - indicates the warning messages.


sorry to disagree with u... I think it should be the other way round.

B'coz if u get an SQLCODE of +100, it's just a warning telling that there are 0 rows being fetched.
But when u get an SQLCODE of -805, it's a definite ERROR and the job is going to abend..

So '-' should be Error, I believe....

Suggestions/corrections are welcome.. :-)
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Fri Nov 09, 2007 6:35 pm
Reply with quote

You are replying to a 3 year old thread!
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Fri Nov 09, 2007 6:47 pm
Reply with quote

I think something weird happened where some old threads show up as changed, like I saw yesterday.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Fri Nov 09, 2007 8:32 pm
Reply with quote

You can find the answer in the fine manual.

O.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Nov 09, 2007 9:45 pm
Reply with quote

Quote:
I think something weird happened where some old threads show up as changed, like I saw yesterday.
Yup, i received a couple of e-mails about some activity, but when i went to the topic, it had not been updated icon_confused.gif
Back to top
View user's profile Send private message
raak

Active User


Joined: 23 May 2006
Posts: 166
Location: chennai

PostPosted: Sat Nov 10, 2007 10:06 am
Reply with quote

oops!!! i dint notice that... stupiiid me icon_evil.gif
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 Return codes-Normal & Abnormal te... JCL & VSAM 7
No new posts AI writing DFSORT, REXX codes.. All Other Mainframe Topics 3
No new posts RXSUBCOM Return Codes / Documentation CLIST & REXX 6
No new posts Sort on different fields, removing du... SYNCSORT 8
No new posts How syntax check at Bind time is diff... DB2 5
Search our Forums:

Back to Top