> As the 1'st file has leading zeros for some of the records 2.73 are > not getting matched . could someone please let me know how to get > this addressed?
Ron, If you looked up the Joinkeys description for FIELDS in the DFSORT Application programming guide you would have found this The keys will be treated as binary, so they must be "normalized". For example, if the keys are actually zoned decimal, they must have all C and D signs, or all F and D signs. You can use an INREC statement in JNF1CNTL and/or JNF2CNTL to normalize the keys for the F1 file and/or F2 file, respectively, if appropriate. Here is the link to that piece of documentation. https://www.ibm.com/support/knowledgecenter/SSLTBW_2.3.0/com.ibm.zos.v2r3.icea100/ice2ca_JOINKEYS_statements.htm So convert your Unsigned Free Format (UFF) to Binary format using INREC and put it at the end of the record (F1 at position 3422 and F2 at position 40) using JNF1CNTL and JNF2CNTL statements respectively). Then adjust the positions on the FIELDS statement to point to the new Binary fields. Coming to the control cards, if you are interested ONLY in the matched record, why bother about unmatched records from F1 and F2 ? By default DFSORT JOINKEYS would always write out only MATCHED records unless you have a JOIN statement. Thanks, Kolusu DFSORT Development IBM Corporation ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
