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

DB2 commit with SQLCODE=-803


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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: 2146
Location: At my coffee table

PostPosted: Tue Mar 03, 2009 7:49 pm
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

Moderator Emeritus


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

PostPosted: Wed Mar 04, 2009 12:32 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts SQLCODE = -122 while using the scalar... DB2 4
No new posts SQLCODE = -16002 when using XMLEXISTS DB2 1
No new posts Is SQLCODE -811 possible while fetchi... DB2 1
No new posts filter COMMIT/ROLLBACK statements DFSORT/ICETOOL 13
No new posts SQLCODE=-204 SQLSTATE=42704 DB2 4
Search our Forums:

Back to Top