Rolling Back Work

The ROLLBACK WORK statement cancels changes made to the database since the last COMMIT WORK or ROLLBACK WORK statement. When you execute the ROLLBACK WORK statement, all updates made by the transaction are cancelled and all open cursors are closed.

The ROLLBACK WORK statement has the following syntax:

SYNTAX
EXEC SQL ROLLBACK WORK ; 


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