Index for Section 5

Alphabetical listing for R

Bottom of page

ROLLBACK(5)
NAME
  ROLLBACK - abort the current transaction

SYNOPSIS
  ROLLBACK [ WORK | TRANSACTION ]

  INPUTS

  None.

  OUTPUTS

  ABORT
       Message returned if successful.

  NOTICE: ROLLBACK: no transaction in progress
       If there is not any transaction currently in progress.

DESCRIPTION
  ROLLBACK rolls back the current transaction and causes all the updates made
  by the transaction to be discarded.

  NOTES

  Use COMMIT [commit(5)] to successfully terminate a transaction.  ABORT
  [abort(5)] is a synonym for ROLLBACK.

USAGE
  To abort all changes:

  ROLLBACK WORK;

COMPATIBILITY
  SQL92

  SQL92 only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise
  full compatibility.

Index for Section 5

Alphabetical listing for R

Top of page