Committing Transactions
When a transaction is committed, its effects on the database are made permanent and visible to other users. Before a transaction is committed, none of its updates to the database are visible to other users, and the transaction can be aborted. An SQT is committed upon execution (barring errors). An MQT is committed when the end transaction statement is executed.
Note: Under certain circumstances, the effects of an uncommitted transaction are visible to other users. For details, see
Set Lockmode Option.
Last modified date: 08/28/2024