Compare two input file using sort.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Previous topicNext topic

Topic author
Mamta LDH
New Member
Posts: 9
Joined: Fri Feb 28, 2014 1:35 am

Compare two input file using sort.

Post by Mamta LDH » Tue Mar 07, 2017 1:42 pm

Hi,

One of my Input file is :

Code: Select all

Robert 26 male 
Ronald 24 male 
Jennifer 22 female 
Second Input file is:

Code: Select all

1245 Robert Newyork 26 AMEX 
1237 Jennifer Nevada 22 RBS 
4356 Ronald Arizona 24 Fox 
Output file should be:

Code: Select all

1245 Robert Newyork 26 AMEX male 
1237 Jennifer Nevada 22 RBS female 
4356 Ronald Arizona 24 Fox male 
Can we do this using SORT, please help me with the process.




nicc
Global Moderator
Global Moderator
Posts: 546
Joined: Wed Apr 23, 2014 8:45 pm

Re: Compare two input file using sort.

Post by nicc » Tue Mar 07, 2017 3:34 pm

search the forum for sort queries involving joinkeys - and read up on the topic in the manual.


Regards
Nic

Previous topicNext topic

Return to “IBM DFSort, ICETOOL, ICEMAN, ICEGENER.”