skip to main content
DataDirect Connect Drivers : DB2 Driver : Connection Properties : WithHoldCursors
  
WithHoldCursors
Purpose
Determines whether the cursor stays open on commit. After a commit, DB2 an leave all cursors open (Preserve cursors) or close all open cursors (Delete cursors). Rolling back a transaction closes all cursors regardless of how this property is specified.
Valid Values
true | false
Behavior
If set to true, the cursor behavior is Preserve.
If set to false, the cursor behavior is Delete.
Default
true
Data Type
boolean