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
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: 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 -- 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
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: IBM-MAIN@BAMA.UA.EDU 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: 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
Re: Identify matching records
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: IBM-MAIN@BAMA.UA.EDU 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: IBM-MAIN@BAMA.UA.EDU 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: 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 -- 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
Re: Identify matching records
or if you have IBM sort look in the archive. Mr. Sort has documented numerous example about how to do this. Jack Kelly 202-502-2390 (Office) -- 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
Re: Identify matching records
From various examples in the DF/SORT web site. //STEP1EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSGDD SYSOUT=* //I DD DISP=SHR,DSN=INPUT1 // DD DISP=SHR,DSN=INPUT2 //MATCH DD SYSOUT=* //NONMATCH DD SYSOUT=* //TOOLINDD * 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
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. //STEP1EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSGDD SYSOUT=* //I DD DISP=SHR,DSN=INPUT1 // DD DISP=SHR,DSN=INPUT2 //MATCH DD SYSOUT=* //NONMATCH DD SYSOUT=* //TOOLINDD * 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
Re: Identify matching records
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. //STEP1EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSGDD SYSOUT=* //I DD DISP=SHR,DSN=INPUT1 // DD DISP=SHR,DSN=INPUT2 //MATCH DD SYSOUT=* //NONMATCH DD SYSOUT=* //TOOLINDD * 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
Re: Identify matching records
Um, there's no H in DFSORT.. -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. //STEP1EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSGDD SYSOUT=* //I DD DISP=SHR,DSN=INPUT1 // DD DISP=SHR,DSN=INPUT2 //MATCH DD SYSOUT=* //NONMATCH DD SYSOUT=* //TOOLINDD * 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 -- 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
Re: Identify matching records
Ooops... just typing to fast under the time crunch. hehe -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Chase, John Sent: Friday, April 25, 2008 12:14 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Identify matching records Um, there's no H in DFSORT.. -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. //STEP1EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSGDD SYSOUT=* //I DD DISP=SHR,DSN=INPUT1 // DD DISP=SHR,DSN=INPUT2 //MATCH DD SYSOUT=* //NONMATCH DD SYSOUT=* //TOOLINDD * 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 -- 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
Re: Identify matching records
I get this from that link Tony. Our apologies... The page you requested cannot be displayed Thanks for the help anyway. Bill -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Tony B. Sent: Friday, April 25, 2008 12:16 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Identify matching records 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. //STEP1EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSGDD SYSOUT=* //I DD DISP=SHR,DSN=INPUT1 // DD DISP=SHR,DSN=INPUT2 //MATCH DD SYSOUT=* //NONMATCH DD SYSOUT=* //TOOLINDD * 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 -- 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
Re: Identify matching records
Append the part that wrapped to the second line. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of George, William (DHCS-ITSD) Sent: Friday, April 25, 2008 2:23 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Identify matching records I get this from that link Tony. Our apologies... The page you requested cannot be displayed Thanks for the help anyway. Bill -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Tony B. Sent: Friday, April 25, 2008 12:16 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Identify matching records http://www-304.ibm.com/systems/support/storage/software/sort/m vs/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. //STEP1EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSGDD SYSOUT=* //I DD DISP=SHR,DSN=INPUT1 // DD DISP=SHR,DSN=INPUT2 //MATCH DD SYSOUT=* //NONMATCH DD SYSOUT=* //TOOLINDD * 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 -- 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
Re: Identify matching records
IBM Mainframe Discussion List IBM-MAIN@BAMA.UA.EDU wrote on 04/25/2008 12:05:54 PM: Thanks, I did go looking for examples in the DFHSORT web site but couldn't locate them. What is this link? The link for the DFSORT website is: http://www.ibm.com/storage/dfsort/ For lots of examples, see the Smart DFSORT Tricks paper at: http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/ You can access all of the DFSORT books from: www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html For complete details on the SELECT operator of DFSORT's ICETOOL with examples, see: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/6.11?DT=20060615185603 For complete details on the SPLICE operator of DFSORT's ICETOOL with examples, see: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/6.13?DT=20060615185603 Frank Yaeger - DFSORT Development Team (IBM) - [EMAIL PROTECTED] Specialties: PARSE, JFY, SQZ, ICETOOL, IFTHEN, OVERLAY, Symbols, Migration = DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/ -- 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
Re: Identify matching records
Just remember that using ALLDUPS to do this assumes there aren't already dupes in either of the files. I usually run the inputs through ICETOOL to drop dupes first and then use those files as input to ALLDUPS. //STEP1EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSGDD SYSOUT=* //INDD DISP=SHR,DSN=INPUT1 //OUT DD DISP=(,CATLG),DSN=INPUT1.NODUPES, // SPACE=(CYL,(100,100),RLSE,UNIT=SYSDA,DCB=*.IN //TOOLINDD * SELECT FROM(IN) TO(OUT) ON(01,10,CH) FIRST /* //* The use INPUT1.NODUPES and INPUT2 as input to the example below. Have a nice day, Dave Betten DFSORT Development, Performance Lead IBM Corporation email: [EMAIL PROTECTED] DFSORT/MVSontheweb at http://www.ibm.com/storage/dfsort/ IBM Mainframe Discussion List IBM-MAIN@BAMA.UA.EDU wrote on 04/25/2008 03:05:54 PM: 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. //STEP1EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSGDD SYSOUT=* //I DD DISP=SHR,DSN=INPUT1 // DD DISP=SHR,DSN=INPUT2 //MATCH DD SYSOUT=* //NONMATCH DD SYSOUT=* //TOOLINDD * 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 -- 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
Re: Identify matching records
Thanks, again... in the crunch of time I missed that wrapping. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of George, William (DHCS-ITSD) Sent: Friday, April 25, 2008 12:23 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Identify matching records I get this from that link Tony. Our apologies... The page you requested cannot be displayed Thanks for the help anyway. Bill -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Tony B. Sent: Friday, April 25, 2008 12:16 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Identify matching records 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. //STEP1EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSGDD SYSOUT=* //I DD DISP=SHR,DSN=INPUT1 // DD DISP=SHR,DSN=INPUT2 //MATCH DD SYSOUT=* //NONMATCH DD SYSOUT=* //TOOLINDD * 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 -- 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
Re: Identify matching records
Thanks Frank. I have saved those links! -- 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
Re: Identify matching records
On Fri, 25 Apr 2008 14:13:38 -0500, Chase, John [EMAIL PROTECTED] wrote: Um, there's no H in DFSORT.. ... Thanks, I did go looking for examples in the DFHSORT web site ... That's the CICS version. :-) Pat O'Keefe -- 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