IBM Mainframe Forum

by **Papya013** » Thu Mar 17, 2016 8:44 pm

I have below mentioned input files:

File1:

3111 252700 HEAD N X 
3111 252800 HEAD N Y

File 2:

Select all

252700 HEAD J
252800 HEAD J
252810 HEAD N

Output I am looking at is:

Select all

252700 HEAD J X 
252800 HEAD J Y
252810 HEAD N

Could you please help me on this. I tried to use join keys but didn't work.

Select all

SORT FIELDS=COPY                       
JOINKEYS FILES=F1,FIELDS=(6,7,A)
JOINKEYS FILES=F2,FIELDS=(6,7,A)
JOIN UNPAIRED,F1,F2                    
REFORMAT FIELDS=(F1:1,20)    

by **NicC** » Thu Mar 17, 2016 9:07 pm

didn't work.

means absolutely nothing unless you state how it doesn't work - with examples if neccessary.

IBM Mainframe Forum

Matched record and unmatched record in the same output file

Matched record and unmatched record in the same output file

Re: Matched record and unmatched record in the same output f