rajantsr
New User
Joined: 31 Jan 2007 Posts: 21 Location: Chennai
|
|
|
|
Hi
when I have a DELETE SQL in my sysin of DSNTIAUL, what will be written into the SYSREC00 ?
Basically my requirement is to get a list of records (Keys) that getting deleted by the SQL into a flat file, is it possible ?
Thanks,
R |
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Rajan,
Quote: |
when I have a DELETE SQL in my sysin of DSNTIAUL, what will be written into the SYSREC00 ? |
Nothing.
Quote: |
Basically my requirement is to get a list of records (Keys) that getting deleted by the SQL into a flat file, is it possible ? |
For this what you can do is........
In the first step you can SELECT the records, based on the condition you gonna delete. And in the next step DELETE the records.
OR
If you are in version 9. You can use the table-change reference technique(FINAL TABLE).
Thank You,
Sushanth Bobby |
|