Page 1 of 1

Read 2 files using sort

PostPosted: Mon Apr 14, 2014 12:32 am
by mail2rr
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?

Re: Read 2 files using sort

PostPosted: Mon Apr 14, 2014 9:12 am
by BillyBoyo
Look at JOINKEYS. It is well documented, and there are many examples here, as well as in the manual.