You could start journalling for your files, this can keep before and after images of your data. SQL itself doesn’t have a before and after print feature like DFU.
Martin is right – as always – first answer Journalling and report from TAATOOL’s journal tools.
You can “simulate” the DFU output but it will require a number of steps in SQL
1.In interative SQL use F13 1. Change session attributes
Change Select output to 2 or 3 so you can capture the before image – remember to set it back to 1
after the process
SELECT output . . . . . . . . 1 1=Display, 2=Printer
2. Use Select * with your file and selection requirements to capture all the before images
3. Do your update
4. Use Select * with your file and selection requirements to capture all the after images
5. F13 – 1 set output to 1
Sorry this is not automatic like DFU. If you’ve written these to a file or files
you can use query to create a report.