View previous topic :: View next topic
|
Author |
Message |
arvind.m
Active User
Joined: 28 Aug 2008 Posts: 205 Location: Hyderabad
|
|
|
|
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 |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
if you have not handled your sqlcode all changes will be roll backed .... |
|
Back to top |
|
|
arvind.m
Active User
Joined: 28 Aug 2008 Posts: 205 Location: Hyderabad
|
|
|
|
if SQLCODE=-803 then abending the program. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
arvind.m wrote: |
if SQLCODE=-803 then abending the program. |
Huh? Is this a question or an admission of guilt? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
if SQLCODE=-803 then abending the program. |
How is the program being abended? |
|
Back to top |
|
|
|