With Hold Cursors Attribute WithHold (WH) Purpose Determines whether the cursor stays open on a commit. Valid Values 0 | 1 Behavior If set to 1 (Enabled), cursor behavior is Preserve, which keeps cursors open after a commit or rollback (SQLGetInfo( ) returns SQL_CB_PRESERVE for SQL_COMMIT_CURSOR_BEHAVIOR). If set to 0 (Disabled), cursor behavior is Delete, which closes all cursors open after a commit or rollback (SQLGetInfo( ) returns SQL_CB_DELETE). Default 1 (Enabled) GUI Tab Advanced tab