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
Compare two files based on key and date range
Moderators: Frank Yaeger, DikDude, Moderator Group
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
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page