MVSFORUMS.com

Dibakar · Last edited by Dibakar on Thu Sep 10, 2026 2:34 pm; edited 2 times in total

Hi,

I have file-aid DB2 RDX extracts of two versions of a database in flat files. I have corresponding XREF and COBOL layout. Is there a way to compare the common fields in the two files. I am thinking of generating file-aid compare cards for these two layouts but checking if a simpler solution exists.

Diba.

Edit:

Comparison report should report all differences at field level with field names and old and new values, like -

kolusu · Posted: Thu Sep 10, 2026 7:56 am Post subject:

Dibakar,

You can use DFSORT's JOINKEYS to compare the files with different layouts. You can check the smart-tricks

https://www.ibm.com/support/pages/smart-dfsort-tricks

Create files with matching and non-matching records

Here is the documentation of JOINKEYS
https://www.ibm.com/docs/en/zos/3.2.0?topic=guide-using-joinkeys-application-joining-two-files
_________________
Kolusu
www.linkedin.com/in/kolusu

Dibakar · Posted: Thu Sep 10, 2026 2:38 pm Post subject:

Thanks Kolusu. I need differences at field level with field names, edited my post with a sample report. I think it would be challenging to do that with DFSORT.
_________________
Regards,
Diba

kolusu · Posted: Thu Sep 10, 2026 8:39 pm Post subject:

Dibakar · Posted: Fri Sep 11, 2026 8:32 am Post subject:

Kolusu,

For input there will be two sets (old and new) each of - File-Aid Xref, Cobol layout and data files. Automation will have to process all these to generate the compare code. It will take some time for me to create them that I can post here.
_________________
Regards,
Diba