Page 1 of 2

Sort card for matched records in 2 different files

PostPosted: Mon Apr 22, 2013 2:40 pm
by Rajesh K
I have two Files.I want a sort card such that the matched records in the two files are written to the output file.Requiring help to write a sample sort card for this asap.

Re: Sort card for matched records in 2 different files

PostPosted: Mon Apr 22, 2013 2:45 pm
by BillyBoyo
Which SORT product do you have?

Look at JOINKEYS. Lots of examples here and in the manuals, on the internet, etc

Re: Sort card for matched records in 2 different files

PostPosted: Mon Apr 22, 2013 2:49 pm
by enrico-sorichetti
Requiring help to write a sample sort card for this asap.

ASAP is a term that should never be used on a forum
replying is on voluntary base and our time availability
if You have time constraints a forum is not the best place to ask for help

Re: Sort card for matched records in 2 different files

PostPosted: Mon Apr 22, 2013 3:09 pm
by Rajesh K
Hi Billy,

Say two files.

FileA

EmpNo EmpName
450 Arun
480 Dinesh
540 Tiffany

FileB

EmpNo EmpName
360 Manoj
480 Dinesh
600 Preethi

I want the mathed records in both the files to be copied in the output file.For this i need sort card.

Re: Sort card for matched records in 2 different files

PostPosted: Mon Apr 22, 2013 3:57 pm
by BillyBoyo
What was the point of "reporting" my post?

Look in the DFSORT or SyncSort forums here for examples of JOINKEYS. You'rs is really simple, but solution depends on the product you are using, which you still haven't bothered to tell us.

If you'd taken the advice earlier, you'd have got to your solution already.

Re: Sort card for matched records in 2 different files

PostPosted: Mon Apr 22, 2013 5:28 pm
by Rajesh K
I want the SORT to be done both in DFSORT and SYNCSORT? Can i get the sort card for this?

Re: Sort card for matched records in 2 different files

PostPosted: Mon Apr 22, 2013 5:35 pm
by BillyBoyo
Yes, just look do what I've mentioned twice already. Find the most simple JOINKEYS you can. That'll be yours.

Re: Sort card for matched records in 2 different files

PostPosted: Mon Apr 22, 2013 7:45 pm
by Rajesh K
Can I have an example for this? I want the sort card.

Re: Sort card for matched records in 2 different files

PostPosted: Mon Apr 22, 2013 7:54 pm
by enrico-sorichetti
I want the sort card.

Unfortunately not always You can have what You want!
this is a help forum, not a provide me with a solution one

show what You have done, what problems You are facing, and somebody will be glad to help You.
Your want/gimme approach will not get You too much sympathy and even less help

what happened when You searched the forum ?
the examples are there and ready to run
yes... I checked :geek:

searching for joinkeys will provide what You want

Re: Sort card for matched records in 2 different files

PostPosted: Mon Apr 22, 2013 8:05 pm
by Rajesh K
Can anybody reply to my query if possible?