DB2 10.5 for Linux, UNIX, and Windows

DB2Command.CommitOnEOF property

Specifies whether an implicit COMMIT is issued immediately after receiving the last row from a result set

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

Syntax

[Visual&nbsp;Basic]
Public Overrides Property CommitOnEOF As Boolean
[C#]
public override bool CommitOnEOF { get; set; }
[C++]
virtual property bool CommitOnEOF {
   bool get () override;
   void set (bool value) override;
}
[JScript]
public override function get CommitOnEOF () : boolean
public override function set CommitOnEOF (value : boolean)

Property value

The CommitOnEOF property supports the following set of boolean values:

: True; False

You can free resources as soon as the application receives the entire result set from cursors by setting the CommitOnEOF property to True (default behavior).

The default is True for connections to DB2® for z/OS® Version 9 and later servers.

The default is False for connections to all other database servers.