Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DSNTIAUL - SYSREC00

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rajantsr

New User


Joined: 31 Jan 2007
Posts: 21
Location: Chennai

PostPosted: Thu Apr 09, 2009 7:45 pm    Post subject: DSNTIAUL - SYSREC00
Reply with quote

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
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Apr 10, 2009 10:40 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Unload from Table with DSNTIAUL delim... suzeet DB2 1 Wed Dec 17, 2014 6:25 pm
No new posts Can you suppress NULLIF char for DSNT... HammerTime DB2 1 Tue Dec 09, 2014 10:00 pm
No new posts SQL QUERY to unload XML rec from DB2 ... gopikrishnan1984 DB2 10 Wed Dec 11, 2013 1:13 pm
No new posts Difference between INZUTILB and DSNTI... rexx77 DB2 1 Tue Mar 26, 2013 7:38 pm
No new posts IKJFT01 Vs DSNTIAUL Rohit Umarjikar DB2 7 Fri May 25, 2012 7:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us