Matched record and unmatched record in the same output file



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Matched record and unmatched record in the same output file

Postby 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:

3111 252700 HEAD J
3111 252800 HEAD J
3111 252810 HEAD N


Output I am looking at is:

3111 252700 HEAD J X
3111 252800 HEAD J Y
3111 252810 HEAD N


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

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)    
Papya013
 
Posts: 35
Joined: Wed Nov 06, 2013 6:53 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby 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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post