[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Using 'With Hold' in DB2 to keep cusors open after commit
- Subject: Using 'With Hold' in DB2 to keep cusors open after commit
- From: John Sayre <John_Sayre@GAP.COM>
- Date: Tue, 28 Jul 1998 16:53:04 -0700
John Sayre@GAPINC
07/28/98 04:53 PM
Is it possible to use 'With Hold' to keep DB2 cursors open after a commit ?
We get -905 errors so much that we have to use frequent commits to avoid
crashing. Restart logic is a big pain, sometimes not possible. We end up
creating huge arrays and using rows from the array to restart the select
statements. Big pain! Time consuming!