Usage Notes
If a LOGOFF command is entered while a transaction is in process (that is, a BEGIN TRANSACTION statement has been entered but an END TRANSACTION statement has not), the transaction is aborted and all affected tables are returned to the state before the BEGIN TRANSACTION statements. See SQL Data Manipulation Language (B035-1146) for additional information about the BEGIN/END TRANSACTION statements.
The following events occur at LOGOFF: