Use SORT to get unique values from one of two files



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

Use SORT to get unique values from one of two files

Postby Matt99 » Fri Dec 15, 2017 1:22 pm

(This was moved from JCL forum group)

Let's say I have two files:

FIle1:
111
222
333

FIle2:
111
333
444

And I want to print all values that are in File1, but not in File2.

So in this case OutFile would be:
222

Can you help me with this?
Matt99
 
Posts: 3
Joined: Fri Dec 15, 2017 1:47 am
Has thanked: 1 time
Been thanked: 0 time

Re: Use SORT to get unique values from one of two files

Postby enrico-sorichetti » Fri Dec 15, 2017 1:45 pm

search the forum, there are quite a few examples dealing with the requirement using JOINKEYS
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post