Compare two input file using sort.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Post Reply
Mamta LDH
New Member
Posts: 8
Joined: Fri Feb 28, 2014 1:35 am

Compare two input file using sort.

Post by Mamta LDH »

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: 691
Joined: Wed Apr 23, 2014 8:45 pm

Re: Compare two input file using sort.

Post by nicc »

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

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

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