Re: cursors and transactions

Brian Finnegan wrote: > > It seems to me that the transaction is implicit if you're > in ansi mode. If that's the case, the delete would close the > cursor (unless it's declared WITH HOLD). [Original message SNIPPED] Just the opposite Brian. Since in ANSI MODE a transaction is begun as soon as the first SQL statement not already contained in a transaction is executed there can only be one transaction at a time in a MODE ANSI database and the delete does not begin a new transaction but becomes part of the implicitely begun transaction already in force. Art S. Kagel