I have 2 files and i match both of them based on key fields using the join function. In the reformat fields I fetch specific fields from both the files and write it in the ouput. Following is the sort card that i am using:
Code:
//SYSIN DD *
JOINKEYS FILE=F1,FIELDS=(1,19,A)
JOINKEYS FILE=F2,FIELDS=(1,19,A)
JOIN UNPAIRED,F1
REFORMAT FIELDS=(F1:1,19,F2,5,4)
SORT FIELDS=COPY
/*
I am using unpaired F1 there by fetching all the fields from the 1st file and only the matching from F2. Whenever there is a match I get the value from file 2 , but if there is no match spaces are populated in the fields positions that need to be populated from F2. But I want to change the logic in such a way that if we find match we need to fetch the value from positions 5,4 of F2 else we need to fetch the value from positions 25,4 in F1. Is there a way to do this? Can somebody help on this
