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
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
:[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
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
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
) 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
: 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=*
//TOOLIN
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
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
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
@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
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
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
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
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
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
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
17 matches
Mail list logo