Using SORT to merge two files

[gopalrathi]

Hi All,

I have a requirement to merge two files as following.
How Can I do this using SORT utility. Our mainframe does not support ICETOOL.

File 1 File 2
============ ===============
Id %1 Id %2
A 45 A 25
A 55 A 75
B 100 B 60
C 75 B 40
C 25 C 100

Output
===============
Id %1 %2
A 45 25
A 45 75
A 55 25
A 55 75
B 100 60
B 100 40
C 75 100
C 25 100

Thanks,
Gopal.

 

[3gm]

Gopal. -

I think you're going to have to write some code to do this as I doubt a standard SORT can manage it.

Regards.

Glenn

 

[WMK]

As you are asking in a COBOL forum, then using a COBOL solution seems reasonable to me. (Using Input procedure to process files)

If you want a non-COBOL solution, check in an IBM (or other mainframe) utility forum.

Bill Klein

 

[jmanj]

First read File 1 one record at a time then read file 2. IF
the ID match then create your output record. You loop thru file1 until end of record. At the end of File1 you can start sorting your ouput file.

Something like this......somewhere in your cobol pgm...

SORT OUTPUT-FILE
ASCENDING KEY ID#
ASCENDING KEY ETC
INPUT PROCEDURE READ-FILE
OUTPUT PROCEDURE WHATEVER.

Is this good enough? OR Do you want us to write some logic?

 

[jmanj]

GOPAL,

What happens if there is no match in File1 or vice versa?

You have to create a code to make it happen. I don't think
SORT or SORT/MERGE utility can do this.

 

[kkitt]

What sort utility are you using on the mainframe and version?

Is the file already in sorted order? The Id tags at the beginning will be a problem if the the file is not already sorted.

This may be possible to do using DFSORT but need to know if you have this availble.