Cursor Behavior Mode |
|
This setting specifies the behavior of the cursor after the end of a transaction. Selecting close all open cursors indicates all cursors that are still open will be closed after any transaction is committed. Selecting preserve cursors and related locks indicates all still open cursors will be kept open after a transaction is committed, and all locks will be preserved; any exclusive locks will become shared. Selecting preserve cursors but release related locks indicates all still open cursors will be kept open after a transaction is committed, but all related locks will be released after the end of the transaction. In all cases, the cursor will be closed if any transaction is aborted. This setting corresponds to the DB_CBMod keyword in the dmconfig.ini file. The default setting is preserve cursors but release related locks .
Related topic: