Need a Sort Card to have matched Records from Two files



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Need a Sort Card to have matched Records from Two files

Postby Rajesh K » Mon Apr 22, 2013 10:04 pm

Hi,

Can anybody provide me a sort card using either DFSORT/SYNCSORT Utility to have matched records from two files.

Say:
File1

Acct.NO Acct.Name
0012 Vishnu
0016 Mohan
0019 Sandra


File2

Acct.NO Acct.Name
0013 Arjun
0016 Mohan
0020 Catherine
Rajesh K
 
Posts: 7
Joined: Mon Apr 22, 2013 2:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Need a Sort Card to have matched Records from Two files

 

Re: Need a Sort Card to have matched Records from Two files

Postby Akatsukami » Mon Apr 22, 2013 10:25 pm

Rajesh K wrote:Hi,

Can anybody provide me a sort card using either DFSORT/SYNCSORT Utility to have matched records from two files.

Say:
File1

Acct.NO Acct.Name
0012 Vishnu
0016 Mohan
0019 Sandra


File2

Acct.NO Acct.Name
0013 Arjun
0016 Mohan
0020 Catherine

No.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: Need a Sort Card to have matched Records from Two files

Postby Robert Sample » Mon Apr 22, 2013 10:32 pm

If your site is authorized to use the sort product, you have access to the manuals (whether through an internal web site, via the vendor web site, or hard copy at your site). You can look up JOINKEYS yourself and write your own SORT statement(s).

In case you haven't figured it out yet, nobody is giving you the SORT statement(s) you need for free -- either pay for help, or accept that this forum will not provide what you (apparently) need and do not have the motivation to find out for yourself. You can ask as many times as you want, but the answer you have received won't change.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: East Dubuque, Illinois
Has thanked: 1 time
Been thanked: 222 times

Re: Need a Sort Card to have matched Records from Two files

Postby NicC » Mon Apr 22, 2013 11:30 pm

And as you cannot even tell us which sort product you use I will move one topic to DFSort and one to Syncsort.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Need a Sort Card to have matched Records from Two files

Postby dick scherrer » Tue Apr 23, 2013 9:37 pm

Hi Nic,

I'm locking this topic also. It is basically a repeat of the other (very similar) topic that has been locked due to Rajesh unwillingness to continue the dialog properly . . .

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Need a Sort Card to have matched Records from Two files

Postby NicC » Tue Apr 23, 2013 10:05 pm

Yes, I left it unlocked just in case he came back. Re-locking.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post