ok. good. For some reason I was thinking the FETCH would not lock
the record. Which does not make sense.
so I just have to declare the cursor to select a single record from
the file. The FETCH locks it. The UPDATE releases the lock.
On Wed, Mar 20, 2013 at 3:22 PM, DeLong, Eric wrote:
I think all you need to do is add the "for update of ... " clause.
As I recall, this forces the fetch to lock the current row, pending
the "UPDATE ... WHERE CURRENT OF myCursor".
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact