Sort card for matched records in 2 different files



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Sort card for matched records in 2 different files

Postby Rajesh K » Mon Apr 22, 2013 2:40 pm

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.
Rajesh K
 
Posts: 7
Joined: Mon Apr 22, 2013 2:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sort card for matched records in 2 different files

Postby BillyBoyo » Mon Apr 22, 2013 2:45 pm

Which SORT product do you have?

Look at JOINKEYS. Lots of examples here and in the manuals, on the internet, etc
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Sort card for matched records in 2 different files

Postby enrico-sorichetti » Mon Apr 22, 2013 2:49 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Sort card for matched records in 2 different files

Postby Rajesh K » Mon Apr 22, 2013 3:09 pm

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.
Rajesh K
 
Posts: 7
Joined: Mon Apr 22, 2013 2:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sort card for matched records in 2 different files

Postby BillyBoyo » Mon Apr 22, 2013 3:57 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Sort card for matched records in 2 different files

Postby Rajesh K » Mon Apr 22, 2013 5:28 pm

I want the SORT to be done both in DFSORT and SYNCSORT? Can i get the sort card for this?
Rajesh K
 
Posts: 7
Joined: Mon Apr 22, 2013 2:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sort card for matched records in 2 different files

Postby BillyBoyo » Mon Apr 22, 2013 5:35 pm

Yes, just look do what I've mentioned twice already. Find the most simple JOINKEYS you can. That'll be yours.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Sort card for matched records in 2 different files

Postby Rajesh K » Mon Apr 22, 2013 7:45 pm

Can I have an example for this? I want the sort card.
Rajesh K
 
Posts: 7
Joined: Mon Apr 22, 2013 2:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sort card for matched records in 2 different files

Postby enrico-sorichetti » Mon Apr 22, 2013 7:54 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Sort card for matched records in 2 different files

Postby Rajesh K » Mon Apr 22, 2013 8:05 pm

Can anybody reply to my query if possible?
Rajesh K
 
Posts: 7
Joined: Mon Apr 22, 2013 2:33 pm
Has thanked: 0 time
Been thanked: 0 time

Next

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post