Read 2 files using sort



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Read 2 files using sort

Postby mail2rr » Mon Apr 14, 2014 12:32 am

I have 2 files. Need to read the file 1 for item number and file 2 which also has item number. If the number match then check in file 2 whether the date field is non zero. if its zero the update the file 2 with the date from file 1. If the date is non-zero no action required just write the record from the file to output file.

we have 2 input and one output file. Can you please suggest what is the best way to implement using SORT?
mail2rr
 
Posts: 1
Joined: Mon Apr 14, 2014 12:26 am
Has thanked: 1 time
Been thanked: 0 time

Re: Read 2 files using sort

Postby BillyBoyo » Mon Apr 14, 2014 9:12 am

Look at JOINKEYS. It is well documented, and there are many examples here, as well as in the manual.

These users thanked the author BillyBoyo for the post:
mail2rr (Mon Apr 14, 2014 1:18 pm)
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post