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:
- 0
- Equivalent connection attribute:
- SQL_ATTR_COMMITONEOF
- Usage notes:
- Starting in DB2® Version
9.7 Fix Pack 5, you can specify whether an implicit COMMIT is issued
immediately after receiving the last row from a result set using the CommitOnEOF CLI keyword.
You
must ensure that the following conditions are satisfied to enable
the
SQL_COMMITONEOF_ON attribute:
- 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.