Indicates whether updates are committed immediately after they are submitted.
| Valid in: | LIBNAME statement |
| Supports: | DB2 under UNIX and PC, Greenplum, ODBC, MySQL |
specifies that all updates, deletes, and inserts are committed (that is, saved to a table) immediately after they are submitted, and no rollback is possible.
specifies that the commit operation is automatically performed when processing reaches the DBCOMMIT= value, or the default number of rows if DBCOMMIT is not set.