I have one Transaction file and one Master file. Master file contains the mapping of Print id and Report Id. However Transaction File has only Print Id. I want to get a output transaction file which will have both Print Id and Report Id for all the records. In other words for each transaction record I want to pull the report id field from Master file. Here are the sample data from two files and expected output. I tried to do it with ICETOOL and SPLICE operator. But not getting the required results. Any suggestion is appreciated!
Assuming that both master and trans file are of same length,you can do this kind of thing more easily and efficiently with the new WHEN=GROUP function of DFSORT available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008) like this