ROLLBACK Syntax Diagram


Closes a logical processing unit by reversing all database changes made since the last COMMIT.

You use this statement if you cannot be certain that all the database changes have been executed correctly.

The update routines are not performed.

ROLLBACK WORK belongs to the Open SQL command set.


If the ROLLBACK statement occurs within a SELECT loop, the processing cannot continue because the database cursor is invalid. Before using the ROLLBACK statement, you should therefore ensure that all SELECT processing has been explicitly terminated.