Neoview ODBC Drivers Manual (R2.5)

Transactions and Cursor Behavior with Multiple Statements
AUTOCOMMIT is a connection-level attribute describing the semantics of transaction
demarcation. AUTOCOMMIT ON defines the semantics where the underlying system
automatically commits the current transaction at statement completion. COMMIT has secondary
effects on open cursors, SELECT statements in an OPEN state, having position in a result set.
AUTOCOMMIT occurs when the connection attribute is ON and any of these secondary actions
occur:
• An UPDATE, INSERT, DELETE statement forces a COMMIT before returning control to the
application.
• A cursor fetch (SELECT) detecting end-of-data, SQL_NO_DATA, is set to the CLOSED state
and becomes unpositioned.
• The statement is directly closed. For example: SQLFreeStatement (..., SQL_CLOSE)
These secondary actions do not result in an AUTOCOMMIT when there is a superior or outer
cursor to this statement. These actions allow an outer cursor to hold position until all rows of
the cursor have been processed, while allowing updates or other cursor operations to occur.
SQL Conformance Level 73