How to know the no of Rows affected with CURSOR

vamseepotti · New User Joined: 21 Oct 2003 Posts: 45

Imagine your CURSOR updated 200 rows and COMMIT takes place. Then abend occurred at 201?215. How u know the number of rows updated by ur cursor and where abend occurred. Now, how u modify ur program which donot update the first 200 rows?

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 Location: USA

Hello vamseepotti,

Code the cursor as below:

sosu4u · New User Joined: 02 Nov 2007 Posts: 2 Location: bangalore

we will know how many records updated or deleted from sqlerrd(3). by checking value in sqlerrd (3) we can start retrieving data from that position.

i think it may help for you.

regards,
suresh

dbzTHEdinosauer · Posted: Mon Jan 11, 2010 4:03 pm

suresh, you are correct. to keep count use sqlerrd(3).

but I think Mayuresh has a better method of restart,
although,
I would

keep the checkpoint area in a db2 table
after the cursor update, I would move the last key updated to a db2 checkpoint table and then commit

.

at end of successful job, I would move a low-key to the checkpoint row, update and commit.

to restart, I would first read my checkpoint row and use the last saved key.

that way at the start of a job, the last saved key would be

low if last run of program was successful
last commited key after an abended run.

PeterHolland · Posted: Mon Jan 11, 2010 4:12 pm

After 6 years this is still not solved?

dbzTHEdinosauer · Posted: Mon Jan 11, 2010 5:10 pm

but you are (were) the last poster to this thread!

Terry Heinze · Posted: Mon Jan 11, 2010 7:32 pm

I hope the original poster has not been sitting at his/her terminal all these years waiting for an answer.