ROLLBACK

Use the ROLLBACK command to abort the current transaction and roll back all changes it has made so far.

Syntax

Syntax for rolling back the current transaction:
ROLLBACK [ WORK | TRANSACTION ]

Inputs

The ROLLBACK command takes the following inputs:
Table 1. ROLLBACK input
Input Description
WORK These are optional keywords that have no effect.
TRANSACTION

Outputs

The ROLLBACK command has the following outputs:

Table 2. ROLLBACK outputs
Output Description
ABORT The command was successful.
NOTICE: rollback: no transaction in progress There is no transaction in progress.

Privileges

You do not need any special privileges to issue this command.

Usage

The following provides sample usage.
  • Abort the current transaction and roll back all changes it has made so far:
    MYDB.SCH1(USER)=> ROLLBACK WORK;