Merge two records based on multiple keys

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
Abhishek Bej
Member
Posts: 1
Joined: Thu Mar 02, 2017 5:30 pm

Merge two records based on multiple keys

Post by Abhishek Bej » Thu Mar 02, 2017 5:41 pm

My first Input file is :

Vishnu 26 male
Vijith 24 male
Swati 22 female

My second Input file is:

1245 Vishnu delhi 26 Samsung
1237 Swati mumbai 22 Intel
4356 Vijith ahmedabad 24 Fox

My output file should be:

1245 Vishnu delhi 26 Samsung male
1237 Swati mumbai 22 Intel female
4356 Vijith ahmedabad 24 Fox male

How to use DFSORT for performing this ?

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