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?