http://www-304.ibm.com/systems/support/storage/software/sort/mvs/professor_s ort/index.html
-----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of George, William (DHCS-ITSD) Sent: Friday, April 25, 2008 2:06 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Identify matching records Thanks, I did go looking for examples in the DFHSORT web site but couldn't locate them. What is this link? Thanks -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Tony B. Sent: Friday, April 25, 2008 12:04 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Identify matching records >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 ---------------------------------------------------------------------- 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
