DB2Command.DisableCursorHold Property

Specifies whether the cursors that a .NET application opens on the server should be left open after committing a transaction.

Namespace:: IBM.Data.DB2
Assembly:: IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax


[Visual&nbsp;Basic]
Public Property DisableCursorHold As Boolean
[C#]
public bool DisableCursorHold {set;}
[C++]
public: __property bool set_DisableCursorHold();
[JScript]
public function set DisableCursorHold():Boolean

Property value

If you set the DisableCursorHold property to true, the cursors that the .NET application opens on the server are closed before the application commits the transaction. Setting DisableCursorHold property to true reduces the cost for applications that do not intend to use the cursor after the transaction is committed.

The default value of the property is false.

Remarks

For XA connections, DisableCursorHold is set to true and cannot be set to false.

If you specify an invalid value for the DisableCursorHold property, an ArgumentException is thrown.