View previous topic :: View next topic
|
Author |
Message |
Sagar Mane
New User
Joined: 12 Feb 2007 Posts: 3 Location: Mumbai
|
|
|
|
Hi I have a requirement to merge two input files. But not using Icetool. We cannot use Icetool here.
The details for the requirement are as follows:
Input1: RECFM=FB and LRECL=600
Input2: RECFM=FB and LRECL=600
Input1:
100~ABCDE~12345~01-01-2007
200~ABCDE~64789~01-01-2005
800~ABCDE~11223~01-01-2006
Input2:
100~ABCDE~12345~xxxx~01-01-1975
800~ABCDE~64789~xxxx~01-01-1944
300~ABCDE~11223~xxxx~01-12-1954
Now I want to merge these two files in such a way that the output file will look like this:
ABCDE1234501-01-200701-01-1975
ABCDE6478901-01-200501-01-1944
ABCDE1122301-01-200601-12-1954
Here the last field i.e. the Birth Date from input file2 is merged to input file1. The key for both the input files is 5 chars from 4th position + 5chars from 9th position. eg. ABCDE(NAME) + 12345(NUMBER).
In cases where input file1 has a record without a match in input file2, and where input file2 has a record without a match in input file1 then we can write spaces for data that is missing in any file. E.g. if Input1 has a record and no matching record in Input2 then we can write spaces in place of Birth Date.
Note: I have added the seperator just to seperate the data. There is no seperator in the actual file. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
What is the reason for not using ICETOOL, apart from the obvious one which is that you do not have DFSORT installed.
Surely if this is the case, then the sort product installed should have some similar logic to ICETOOL. |
|
Back to top |
|
|
Sagar Mane
New User
Joined: 12 Feb 2007 Posts: 3 Location: Mumbai
|
|
|
|
I dont know for what reason but the client doesnt want to use Icetool. So I am searching for the same with SORT. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Which sort product are you using at this client location? |
|
Back to top |
|
|
|