BEGIN ATOMIC is different in two ways. First, the operations are undone automatically (no ROLLBACK statement). Second, you are not undoing everything from the beginning of the transaction, but just to the beginning of the compound statement. This is most useful when you are doing EXCEPTION handling.