compare two files using SORT

[anu.slaksh]

i need to compare two files using SORT.

Here is my requirement:
I have two input files
input 1: length 850
input 2: length 200

I need to compare the (9,9,ch) of both the files. this 9,9 indicates the account number starting from 9th position with length 9. For those accounts that has a match in the input file,the (114,3,ch) data has to be fetched from the input 2.
That is there is a label for each account in input 2. i need to fetch those labels for every match in account in both the files.
Regarding duplicates, there will be duplicates in both the files.
i want to ignore the duplicates.

How can this be done using a sort?? I cant use ICETOOL. Can my
requirements be done using SORT CARD??
_________________
anu

[Frank Yaeger]

[anu.slaksh]

input 1:

colu 9
-------
111111111
111111111
222222222
333333333

INPUT2:

COL 9 COL144
----------- ----------

111111111 ABC
222222222 ABN
222222222 ABN
333333333 EGL

Output:
---------
ABC 111111111
ABN 222222222
EGL 333333333

Here is my sample input and output..
am fine with ICETOOL also..
_________________
anu

[Frank Yaeger]

You can use a DFSORT/ICETOOL job like the following to do what you asked for.

Note: You said 114,3,CH in your first post, but showed COL144 in your last post. I assumed it's 144 - if it's 114, just change the job appropriately.

[anu.slaksh]

its working perfectly..
thnks...
_________________
anu