Ron, I believe that is what it does with the statements you have. The two input files (F1 and F2) are sorted based on the specified FIELDS operands before they are joined, unless you indicate that an input file is already sorted on the JOINKEYS statement.
Or are you expecting the actual input file to be rewritten, sorted on the first 8 char? Bart -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Ron Thomas Sent: Thursday, October 23, 2014 12:16 AM To: [email protected] Subject: DFSORT Hello We have the below sort card in production, we are joining on the first 8 bytes . The file is currently unsorted on 1-8 bytes . Could some one please let me know how to modify the control card to do the sort on 1'st 8 bytes and then do a join ? JOINKEYS F1=ITEM,FIELDS=(01,08,A) JOINKEYS F2=CLUB,FIELDS=(01,08,A) REFORMAT FIELDS=(F1:5,167,F2:1,4,9,78) SORT FIELDS=(1,4,BI,A, 168,4,BI,A) Thanks Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
