Ron, The JOINKEYS feature indeed treats the keys to compare as binary. If both files have keys in binary format, you can compare them straight away without any normalization. However if you have 1 key in binary and the other key in ZD/PD/UFF/SFF format then you need to normalize them. 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.
Check this link which explains in detail about the JOINKEY Statement http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA60/4.3 See the smart DFSORT trick "Create files with matching and non-matching records" for examples here http://www-01.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094 Thanks, Sri Hari Kolusu DFSORT Development IBM Corporation Email: skol...@us.ibm.com Phone: 408-463-2403 Tie Line 543-2403 IBM Mainframe Discussion List <IBM-MAIN@listserv.ua.edu> wrote on 02/20/2013 07:44:35 AM: > From: Ron Thomas <ron5...@gmail.com> > To: IBM-MAIN@listserv.ua.edu, > Date: 02/20/2013 07:52 AM > Subject: DFSORT > Sent by: IBM Mainframe Discussion List <IBM-MAIN@listserv.ua.edu> > > Hello. > > I have 2 files of 80 bytes length and need to compare using joinkeys > to get the matched and unmatched records in each of 2 files. The > issue is data that need to be joined is a binary data. The picture > clause is s9(09) comp which is the customer number and this is the > 1'st field in the record. > > Could someone please let me know how to do the same? > > Regards > Ron T > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
