syncpoint in cursor

EnjoyMF · Active User Joined: 27 May 2005 Posts: 92

Hi all

if in a cics db2 table i try to update the tables (ie some 1000 rows to be updated)i use the cursor to fetch the row and update that

but the question is as the WITH HOLD option is not used & as commit or sync point is not issued ( as cursor is closed if syncpoint is used) ..what happens to the updated rows if any abend occurs...

Thanks
prasad

jkbytes · Posted: Sat May 28, 2005 11:05 am Post subject:

Hi Prasad,

As far as the criteria that you have mentioned ie. you didn't use a with hold in the cursor def and you din't issue a COMMIT.

The result is that thew changes you have requested will be rolled back to the previous syncpoint.

If you have issued a commit, then all the work will be saved when it comes across a COMMIT, and your cursor will be closed and a syncpoint will be established, but unless you have defined it with a WITHHOLD option your cursor wont be closed.