Could you please help me in getting the desired output through ICETOOL.
Explanation:
The records from both the input files should be matched based on the field EMPNO and needs to be written in the fashion as shown below. The output should written as a matrix form which you will be able to exactly understand by looking at the output structure.
In the input file-1 if it has one record for e.g take a record with EMPNO = 100 and the fie-2 has 2 records then it will write the output as 2 occurences of the EMPNO giving 2X1 matrix keeping the LOC field as same of the above for both the records in the output. Similarly the same thing happens for all the records with different EMPNO.
There is one more logic as you can see in the structure the input file-2 has one more field NAME. The name field will be overlayed in the output file as shown.
The length of each field EMPNO, LOC and NAME can assumed as 10 bytes. Input files can have RECFM=FB and LRECL=80,
Please refer to the below output structure for more clarity.
Code: Select all
Input:
File-1
EMPNO LOC
100 MUM-A
200 DEL-B
200 DEL-C
300 COI-A
300 COI-B
300 COI-C
400 KOL-P
400 KOL-Q
600 CHE-Z
File-2
EMPNO LOC NAME
100 MUM-P
100 MUM-Q
200 DEL-R
300 COI-S
300 COI-T BECKY
300 COI-U
300 COI-V
400 KOL-E RONAL3
400 KOL-F RONAL2
500 NOI-G
Output:
100 MUM-A
100 MUM-A
200 DEL-B
200 DEL-C
300 COI-A
300 COI-B
300 COI-C
300 COI-A BECKY
300 COI-B BECKY
300 COI-C BECKY
300 COI-A
300 COI-B
300 COI-C
300 COI-A
300 COI-B
300 COI-C
400 KOL-P RONAL3
400 KOL-Q RONAL3
400 KOL-P RONAL2
400 KOL-Q RONAL2
Note:
If the BECKY would have been on this record "300 COI-U BECKY" then the output would be as below. I have shown the below output only for EMPNO = 300 and so on.
Code: Select all
Input
300 COI-S
300 COI-T
300 COI-U BECKY
300 COI-V
Output:
300 COI-A
300 COI-B
300 COI-C
300 COI-A
300 COI-B
300 COI-C
300 COI-A BECKY
300 COI-B BECKY
300 COI-C BECKY
300 COI-A
300 COI-B
300 COI-C