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.

Default

true

Data Type

boolean