skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The DB2 Wire Protocol Driver : Connection Option Descriptions : With Hold Cursors
  
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