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
 

 

To pic only changed records

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Rajkumar_n

New User


Joined: 07 Dec 2006
Posts: 51
Location: Bloomington

PostPosted: Tue Jul 05, 2011 2:22 pm    Post subject: To pic only changed records
Reply with quote

Hi,

I would like to know if there is any way to compare two records and bringout only the changed record in the output file.

I am getting a large volume of data and I am processing whole data at present. We are getting already received data in the input file, so instead of processing already processed record, I would like to process only delta records (i.e new or record with updated information).

Does any one is aware of any utility with which I can bring out only delta records.

Thanks and Regards,
Rajkumar Nerella
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Tue Jul 05, 2011 2:47 pm    Post subject:
Reply with quote

Rajkumar Nerella,

dfsort can do this, conditionally.

what conditions? depends on a little more input from you.

or you could skip having to explain yourself,
and search the forum for
1 of probably 20 or 30 similar requests for someone else to think for you and do your job
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Tue Jul 05, 2011 8:02 pm    Post subject:
Reply with quote

Rajkumar_n,
Are you trying to compare records from 2 different files or 2 records in the same file?

Please provide sample input and expected output along with LRECL and RECFM for input and expected output. Also mention if you want to compare just the key fields or the entire record itself.

Last but not the least, provide us with your DFSort function level as well. Refer to this post on how to find your DFSort function level.

http://ibmmainframes.com/viewtopic.php?t=33389

Thanks
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Jul 05, 2011 11:47 pm    Post subject:
Reply with quote

Rajkumar,

You can use DFSORT's JOINKEYS function to do this kind of thing. For more details, see the "Create files with matching and non-matching records" Smart DFSORT Trick at:

http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094

If you need more specific help, give more detailed information on what you want to do, including an example of input and expected output.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm


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