To pic only changed records

Rajkumar_n · Posted: Tue Jul 05, 2011 2:22 pm

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

dbzTHEdinosauer · Posted: Tue Jul 05, 2011 2:47 pm

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

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

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.

ibmmainframes.com/viewtopic.php?t=33389

Thanks

Frank Yaeger · Posted: Tue Jul 05, 2011 11:47 pm

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:

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.