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
 

 

DB2 commit with SQLCODE=-803

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
arvind.m

Active User


Joined: 28 Aug 2008
Posts: 205
Location: Hyderabad

PostPosted: Tue Mar 03, 2009 7:08 pm    Post subject: DB2 commit with SQLCODE=-803
Reply with quote

Hi All,

If a cobol-db2 program is updating the a table for different items and at some point it fails with SQLCODE=-803 and the job abends. Is the previous updated records will roll back. there is no COMMIT statement in the program. Below are the bind parameters for my program

Code:

CURRENTDATA(NO)             
DYNAMICRULES(RUN)           
VALIDATE(BIND) EXPLAIN(NO) 
FLAG(I) ISOLATION(CS)       
DBPROTOCOL(DRDA)           
RELEASE(COMMIT)             
NOREOPT                     
ENABLE(*)                   
 
Back to top
View user's profile Send private message

ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Tue Mar 03, 2009 7:16 pm    Post subject:
Reply with quote

if you have not handled your sqlcode all changes will be roll backed ....
Back to top
View user's profile Send private message
arvind.m

Active User


Joined: 28 Aug 2008
Posts: 205
Location: Hyderabad

PostPosted: Tue Mar 03, 2009 7:45 pm    Post subject:
Reply with quote

if SQLCODE=-803 then abending the program.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Tue Mar 03, 2009 7:49 pm    Post subject:
Reply with quote

arvind.m wrote:
if SQLCODE=-803 then abending the program.
Huh? Is this a question or an admission of guilt?
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: Wed Mar 04, 2009 12:32 am    Post subject:
Reply with quote

Hello,

Quote:
if SQLCODE=-803 then abending the program.
How is the program being abended?
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 SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Commit limit for Delete query through... mf_karthik DB2 10 Thu Dec 17, 2015 12:56 am
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts Commit a DB2 Table on Unix Server and... Vinodh S DB2 3 Sun Apr 12, 2015 5:05 am


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