Parameters—Rollback Statement
This statement has the following parameters:
work
Is an optional keyword included for compatibility with the ISO and ANSI SQL standards
to savepointname
Rolls back only those changes made after the specified savepoint. The transaction is not terminated. Processing resumes with the statement following the rollback to savepointname statement. If autocommit is enabled, the rollback statement has no effect.
If rollback is issued without the optional to clause, the statement terminates the transaction and rolls back any changes made by the transaction.