Thanks John and Dave... looking into it now! Bill
-----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Reda, John Sent: Friday, April 25, 2008 11:28 AM To: [email protected] Subject: Re: Identify matching records Dave is right, this is a snap for JOIN. If you have SyncSort for z/OS 1.2 or higher. Send me an offline email or I will work on the syntax with you. My email is [EMAIL PROTECTED] John Reda Syncsort, Inc 201-930-8260 -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Gibney, Dave Sent: Friday, April 25, 2008 2:24 PM To: [email protected] Subject: Re: Identify matching records Look at the JOIN function in Syncsort -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of George, William (DHCS-ITSD) Sent: Friday, April 25, 2008 11:06 AM To: [email protected] 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 ---------------------------------------------------------------------- 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
