Release 10.1A: OpenEdge Data Management:
SQL Development

> ## ROLLBACK statement

> The `ROLLBACK` statement undoes all the changes made to the database within a transaction. The `ROLLBACK` statement uses the following syntax:

> Syntax

>     ROLLBACK [ WORK ];

> The following example shows how to use the `ROLLBACK` statement:

>      ROLLBACK WORK ;

> Notes: 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 .

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095