joinkeys in sort

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

Moderators: Frank Yaeger, Moderator Group

Post Reply
sivasaras
Member
Posts: 45
Joined: Tue Jun 15, 2010 3:07 pm

joinkeys in sort

Post by sivasaras » Wed Sep 23, 2015 7:32 pm

hi,

I have 2 files OF SAME LRECL
.
1st file

LRECL=255,BLKSIZE=27795

aaa BA.BSV.jK KRITHIKA

2nd file

LRECL=255,BLKSIZE=27795
krithika MBBS ABCDFG

now i want the report in the single line with the comparison of 2 files like

AAA BA.BSV.JK KRITHIKA MBBS ABCDFG


please let me know how to do that?

bernix
Member
Posts: 21
Joined: Tue Oct 28, 2008 8:32 pm
Location: Vienna, Austria

Post by bernix » Thu Oct 22, 2015 5:26 pm

JOINKEYS F1=IN1,FIELDS= <position of common key in file1>
JOINKEYS F2=IN2,FIELDS=<position of common key in file2>
REFORMAT FIELDS=(F1: <fields of file1>,F2: <fields of files2> )
OPTION COPY
END

(if you have variable length records you need a RDW as well

academyindia4

Topic deleted by Admin

Post by academyindia4 » Mon Feb 01, 2016 10:00 pm

<< Content deleted By Admin >>

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