Progress
Embedded SQL-92
Guide and Reference
ROLLBACK Statement
The ROLLBACK statement undoes all the changes made to the database within a transaction.
EXAMPLEThe following example shows how to use the ROLLBACK statement:
The ROLLBACK statement does not affect the contents of any host variables or the flow of control in the ESQL program. The database issues a ROLLBACK operation automatically when there is an abnormal termination of the application program. Often, the ROLLBACK statement is used in exception handler routines.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |