Need help with File Compare and Fields Comparision

satish.ms10 · Active User Joined: 10 Aug 2009 Posts: 184 Location: India

Hi All,

I am currently working on a task, task is to compare two sorted files on key field and report report as below. If keys are matched then I need to compare FLD2, FLD4, FLD5 from both the files

Here is the sample input

sergeyken · Posted: Mon Apr 17, 2023 4:51 pm

Please, take one of THOUSANDS of existing examples, and TRY TO DO SOMETHING by yourself. Only in that case it can be discussed at this forum.

Your sample of input is not related in ANY MANNER to your sample of output data. At least it is not obvious.

Hints:
1) read about the statements JOINKEYS, JOIN, and REFORMAT
2) read about the parameters IFTHEN=, and WHEN=

Joerg.Findeisen · Posted: Thu Apr 20, 2023 1:26 pm

Basically it's possible to do it using SORT. I am able to get the following results:

Rohit Umarjikar · Posted: Fri Apr 21, 2023 5:02 pm

Moved to student section.
www.ibm.com/docs/en/zos/2.3.0?topic=files-joinkeys-statements

satish.ms10 · Active User Joined: 10 Aug 2009 Posts: 184 Location: India

Hi All,

Apologies for the late reply.

I have started exploring JOINKEYS and REFORMAT in DFSORT to implement solution for my request, however, customer confirmed to write the code in COBOL so I am writing code in COBOL.

Thank you so much for your guidance.

Thanks,
Satish

Rohit Umarjikar · Posted: Sat Apr 22, 2023 2:21 am

Okay thanks if you ever wonder how to do it using DFSORT then give it a try .. it’s better than cobol program and customer may like it too .

Joerg.Findeisen · Posted: Sun Apr 23, 2023 9:25 pm

Also to mention, for the given sample, it's just a little more than 50 lines of SORT statements. The challenge is not the join operation itself, but the floating field comparison afterwards.