Try OpenEdge Now
skip to main content
SQL Development
Data Control Language and Transaction Behavior : Working with transaction control : ROLLBACK statement
 

ROLLBACK statement

The ROLLBACK statement undoes all the changes made to the database within a transaction. The ROLLBACK statement uses the following syntax:
ROLLBACK [ WORK ];
The following example shows how to use the ROLLBACK statement:
ROLLBACK WORK ;
Note: The ROLLBACK statement does not affect the contents of any host variables or the flow of control in the program. The database issues a ROLLBACK operation automatically when there is an abnormal termination of the application program.
For more on the ROLLBACK statement, see OpenEdge Data Management: SQL Reference.