Compare two files based on key and date range

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
mandia
Member
Posts: 3
Joined: Tue Jan 15, 2013 7:27 am

Compare two files based on key and date range

Post by mandia » Tue Jan 15, 2013 8:22 am

Hi,

I have a requirement to compare two files based on key account number and also check if effect date in file1 lies between FROM and TO DATE in file2.Date fields are of format YYYYMMDD.

Records that match the above criteria are written in file3 and unmatched ones in file4.

All files are of record format FB .
File1,2,3 and 4 are of length 15,23,15 and 15 respectively.
File1 and file 2 can have duplicate account numbers but both have 1-1 relationship.

Example:

INPUT
FILE1
ACCNO EFFECTDATE
1234567 20121201
1234567 20121130
2345678 20130109

FILE2
ACCNO FROMDATE TODATE
1234567 20121130 20121230
1234567 20121130 20121213
2345678 20121030 20121230


OUTPUT
FILE3
ACCNO EFFECTDATE
1234567 20121201
1234567 20121130

FILE3
ACCNO EFFECTDATE
2345678 20130109

Please suggest on how to achieve this using JCL.

Thanks !!
mandia

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Wed Jan 16, 2013 1:23 am

What you want to do cannot be done by JCL . . . JCL will only execute "things".

To do what you want, you would probably want to use your sort product. Read about JOINKEYS in your sort documentation or look for some samples using our Search function above.
Have a good one

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others