Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## ROLLBACK

> Ends the current transaction and undoes any database changes performed during the transaction.

> #### Syntax

>     ROLLBACK [ WORK ] ;

> #### Notes

> - Under certain circumstances, SQL marks a transaction for abort but does not actually roll it back immediately. Without an explicit `ROLLBACK`, any subsequent updates do not take effect. A `COMMIT` statement causes SQL to recognize the transaction as marked for abort and instead implicitly rolls back the transaction.

> - SQL marks a transaction for abort in the event of a hardware or software system failure. This transaction is rolled back during recovery.

> ##### Authorization

> None

> ##### Related statements

> COMMIT

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