ROLLBACK performs the following actions:
- Backs out changes made to the database as a result of the transaction.
- Deletes spooled output for the request.
- Releases locks associated with the transaction.
- If the transaction is in the form of a macro or a multistatement request, bypasses execution of the remaining statements.
- Returns a failure response to the user.