STRDFU utility
I would like to get the pre & Post image of changes when I update data using SQL. Currently I am getting this facility when I update thru STRDFU utility.
Software/Hardware used:
Software/Hardware used:
ASKED:
March 27, 2009 10:30 AM
UPDATED:
March 31, 2009 5:05 PM
Answer Wiki:
Hi,
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.
Regards,
Martin Gilbert.
//////////////////////////////////////////////////////////////////////////////////////
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
3=File
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.
Phil
To see all answers submitted to the Answer Wiki: View Answer History.
And if you want to spend money, NetIQ has Secure SQL that will do transaction journal without journaling the file.
Beside being a long time as400 admin, I’ve got a CISA and have done a lot of security work for SOX and PCI. If you have either of those requirements, particiarly PCI you may as well bite the bullet and buy NetIQ or someones iSeries security package. After having seen programmers produce security reports by quering object outfiles and journals, I no longer trust in-house code for security reporting. Too many programmers have either programed logic holes or created intentional exclusions of information that makes their audit reporting inaccurate and unacceptable and eventually auidtors are going to be reluctant to accept in house code for audit reporting. I know I would make a company’s life miserable if I found contradictions and had to start reviewing every line of source for audit pgms.