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
 

 

What's the Diff +and - Sql Codes

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: What's the Diff +and - Sql Codes
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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: 2360
Location: Israel

PostPosted: Fri Nov 09, 2007 8:32 pm    Post subject:
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

Site Director


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

PostPosted: Fri Nov 09, 2007 9:45 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Compare PD Values with same storage &... Shrinika Rajendran JCL & VSAM 5 Wed Nov 05, 2014 3:17 pm
No new posts merge records from 2 ps files with di... kishpra DFSORT/ICETOOL 6 Wed Mar 19, 2014 1:00 pm
No new posts Need help on SORT to write each input... rahul sijoriya JCL & VSAM 4 Mon Dec 02, 2013 9:09 pm
No new posts JCL Cond Codes Vivek Anand JCL & VSAM 7 Tue Sep 03, 2013 4:49 pm
No new posts Need information about Endevor return... sivasaras CA Products 1 Thu Apr 18, 2013 8:50 pm


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