UNDO Changes

If you decide to UNDO the changes, you need to generate UNDO SQL only for the specific program, user and job that made the updates. Filtering should allow you also to limit the generated SQL to certain rows in the table by specifying a WHERE clause. The generated SQL can be executed immediately using the MODE EXEC option. Important is that the tool generates the UNDOs in the right order, for example, rows of child tables are to be deleted before the associated parent row can be deleted.