How to Use DFSORT JOINKEYS to Get Matching Records

DFSORT Logic to get matching records from two or more input files, using the JOINKEYS parameter.


Syntax for JOINKEYS

JOINKEYS F1=IN1,FIELDS=(22,3,A,55,9,D) 


  • You should not use the same DD name on two statements (in F1 and F2)
  • The order for both files should match (A- Ascending and D -Descending should be the same)

Also read

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.