SQL Commit

meenakshi_forum · Active User Joined: 27 May 2008 Posts: 121 Location: India

Hi,

Suppose there is a cursor which is expected to(this is just an assumption) to fetch 1000 records but after fetching every 2nd record the tracnscations are expected to be commited, then what would happen to the cursor?

Thanks!

Escapa · Posted: Mon Apr 26, 2010 3:47 pm

The best would be "try yourself" and then if you are blank about why this is happening "so" post it here.

Kjeld · Posted: Mon Apr 26, 2010 4:04 pm

Hint: It makes a difference if you define you cursor with WITH HOLD or not.

dbzTHEdinosauer · Posted: Mon Apr 26, 2010 4:05 pm

look-up the WITH HOLD clause, in a db2 manual, or try google.

sushanth bobby · Posted: Mon Apr 26, 2010 6:59 pm

meenakshi_forum, Hi

Why do you want to fetch a record and commit ?

Are you updating anything ?

Sushanth

Kjeld · Posted: Mon Apr 26, 2010 7:13 pm

If you use checkpoint/restart logic your output dataset is part of the LUW. Besides you might want to release any locks held.