CommitOnEOF IBM data server driver 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.
- Equivalent CLI keyword
- CommitOnEOF
- Equivalent IBM® Data Server Provider for .NET connection string keyword
- CommitOnEOF
- db2dsdriver.cfg configuration syntax
<parameter name="CommitOnEOF" value="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 operation is issued when the last row from the result set of the last cursor is read.