I have 1 input file and a lookup file. Lookup file contains 2 fields one is the Child, and another is the Parent and each of 6 bytes long, char type and the file is of FB type.
Now the input file is a pure report with all the header, details etc.. and produced outside of Mainframes and gets into Mainframes.
It is of type FB and the length is 227 bytes. This has the Child keys present in byte 13 and length is 6.
My requirement is to read the key from the file and look in the look up file, get the parent value and put it in the input report record in position 2 and copyt it into output file.
The catch here the input report file shouldn't be sorted and Look up file is just the input file. The o/p file needs to be an exact copy of the input file but with the parent key value. if the key is not found it can put blanks in parent but still copy the record to output file.
I thought of implementing this using Easytrieve or Syncsort. Just want to know if Syncsort can do it in simple way.
I have searched for JOINKEYS but it appears to be doing sort and reformatting. So, please let me know if there is any better way to do it in Syncsort.