Cause of Rollback

Rollbacks can occur either due to an explicit user request, or automatically.

Use a ROLLBACK statement to undo any changes to the database since the last COMMIT or ROLLBACK.

Use a ROLLBACK TO SAVEPOINTstatement to undo any changes to the database since the SAVEPOINT you name, or else to the last SAVEPOINT.

SAP Sybase IQ rolls back the database automatically if a user is in a transaction and then logs out or disconnects without committing. The rollback is to the most recent commit or rollback.