-- This is where the actual deletes are done.
-- DO NOT run this statement unless FINDDUPES
--   has completed successfully.
--
-- The DUPV4 view references the original file
--   and exposes the record numbers. We can now
--   use a sub-SELECT to delete only records that
--   appear in our "duplicates" views.

DELETE FROM MYLIB/DUPV4
    WHERE DUPRRN in (
        SELECT MRRN FROM MYLIB/DUPV3
        )
;