Can you please help me out to resolve this problem.
We'd like to, but you haven't actually described the "rules" for what you want to do clearly, and your restriction against using ICETOOL is problematical.
As for the rules, you show the two files both with these "keys":
The "keys" match up in this case. But I suspect there are other possible variations such as:
Here the "keys" don't match up and I don't know what rules you want to use for that situation or other possible situations, or even what the other possible situations can be. Your example doesn't tell me much.
We can't give you a solution when we don't understand what you want to do and Kolusu and I really don't have time for guessing games as we have "day jobs" developing DFSORT.
I am working on this scenario for the past 3 days and it is very critical now.
Wouldn't that have been enough time to write a program in the language of your choice (or are all languages disallowed at your site as well?).
Sorry Frank. The requirement is like this. File-1 has duplicates records and File-2 is unique. We should merge both the files based upon key fields.
I.e. For each occurance of File-1 should merge with file-2 based upon unique key field.
Data - 1
Data - 2
The output is,
Data - 3
ID Name DOB
001 Ashok 07MAR1984
002 Bharath 02JAN1982
002 Bharath 04APR1981
003 Anand 17NOV1985
I think now it is pretty much clear. Thanks for your response.
Please do the needful.
Here's a DFSORT/ICETOOL job that will do what you asked for. I assumed the name field can be a maximum of 12 characters. Be sure to use your Data 1 file (DOB,ID) as IN1 and your Data 2 file (ID,Name) as IN2.
Frank, the statements SPLICE, COPY those sort of ICETOOL commands wont work in our production servers. Thats the challenge in this scenario. Please dont say that "ICETOOL is a part of DFSORT". I am not sure about the reason behind this mystery.
But, here we have to go only with DFSORT commands.
Anyway, thank you very much for your prompt response.