Purpose

Determines whether the cursor stays open on commit. After a commit, Db2 can 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.

Data Source Methods

public Boolean getWithHoldCursors()

public void setWithHoldCursors(Boolean)

Default

true

Data Type

Boolean