DB2 10.5 for Linux, UNIX, and Windows

CommitOnEOF CLI/ODBC configuration keyword

Specifies whether an implicit COMMIT is issued immediately after receiving the last row from a result set. You can free resources as soon as the application receives the entire result-set from a cursor by using this keyword.

db2cli.ini keyword syntax:

CommitOnEOF = 0 | 1

Default setting:

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

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

Equivalent connection attribute:

SQL_ATTR_COMMITONEOF

Usage notes:

To enable the CommitOnEOF keyword setting with a value of 1, ensure that the following conditions are met:

The autocommit mode is enabled.
The cursor is read-only and forward-only.
The SQL_ATTR_EARLYCLOSE statement attribute is set to SQL_EARLYCLOSE_ON (default).

If stored procedures or applications return multiple result sets, a COMMIT is issued when the last row from the result-set of the last cursor is read.