Progress
Embedded SQL-92
Guide and Reference


ROLLBACK Statement

The ROLLBACK statement undoes all the changes made to the database within a transaction.

EXAMPLE

The following example shows how to use the ROLLBACK statement:

/* 
** Undo transaction changes
*/
EXEC SQL ROLLBACK WORK ; 

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