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