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