>From various examples in the DF/SORT web site.....
//STEP1 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //I DD DISP=SHR,DSN=INPUT1 // DD DISP=SHR,DSN=INPUT2 //MATCH DD SYSOUT=* //NONMATCH DD SYSOUT=* //TOOLIN DD * SELECT FROM(I) TO(MATCH) ON(01,10,CH) ALLDUPS DISCARD(NONMATCH) matching on columns 1-10. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of George, William (DHCS-ITSD) Sent: Friday, April 25, 2008 1:06 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Identify matching records We have an IMMEDIATE need to identify records in two files that match. One file has several million records while the other has about ½ million. We need to locate all records in the smaller file that are also in the larger file ASAP. I pose this to the group just in case someone can identify a means via SORT, SUPERC or some other means faster than I can research to find an existing method or building one. Thank You for any insights. Bill ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.4/1397 - Release Date: 4/25/2008 7:42 AM No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.4/1397 - Release Date: 4/25/2008 7:42 AM ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.4/1397 - Release Date: 4/25/2008 7:42 AM ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
