Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Positive Err and Negative Err in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
kumar_ngl
Warnings : 1

Active User


Joined: 05 Aug 2005
Posts: 51
Location: chennai

PostPosted: Wed Aug 31, 2005 9:51 am    Post subject: Positive Err and Negative Err in DB2
Reply with quote

Plz any one give me a clear explanation about positve errors and negative errors in DB2,

thanks,
kumar.p.v
Back to top
View user's profile Send private message
References
prasanth_thavva

Active User


Joined: 28 Jul 2005
Posts: 103
Location: Bangalore

PostPosted: Wed Aug 31, 2005 10:10 am    Post subject: Positive Err and Negative Err in DB2
Reply with quote

hi,
positive errors means +100 it will work but it gives some warnings ..etc
+100 means no more data after fetching the last one in a resultant table(cursor).
-818 time stamp token mismatch between Application plan and loadmodule this is severe error that is negative...
but both the cases u have to handle the situation with Handle condition are else best method is SQLCODE..OR SQLSTATE....DEPends on ur application design.
bye
all d best
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1