IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


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
Post a reply

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
Top

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: 3006
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 165 times
Top
Post a reply

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks