STRDFU utility

60 pts.
Tags:
Data File Utility
SQL
Start DFU
STRDFU
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • DanD
    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.
    2,865 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following