Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Write match & mismatch recs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
prabs2006

Active User


Joined: 12 Jan 2006
Posts: 103

PostPosted: Mon Mar 20, 2006 9:12 pm    Post subject: Write match & mismatch recs
Reply with quote

Hi,

I have 2 files( FileA & FileB) and 2 output files(Filec & FileD).

I have to write all the matching records from File A & File B to File C.
I have to write all the records from File A to File D which are not matcing with File B.

Is it possible to do the above logic in SORT?

Thanks & Regards
Prabs
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Mon Mar 20, 2006 10:11 pm    Post subject:
Reply with quote

You can use a variation of one of the jobs shown in the Smart DFSORT Trick at:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst02.html#t05
Back to top
View user's profile Send private message
muffirulz

New User


Joined: 14 Sep 2005
Posts: 74
Location: Kentucky, USA

PostPosted: Mon Mar 20, 2006 10:16 pm    Post subject: Re: Write match & mismatch recs
Reply with quote

hi frank,

Can you tell me a way to use sort for the above problem because I am also facing the same problem

Thanks
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Mon Mar 20, 2006 10:22 pm    Post subject:
Reply with quote

Quote:
Can you tell me a way to use sort for the above problem because I am also facing the same problem


I don't understand what you're asking. The Smart DFSORT Trick I gave the link for shows how to use DFSORT's ICETOOL for various types of matching operations. ICETOOL is part of DFSORT (has been since 1991). So a variation of one of the jobs shown there would be the way to use sort for the above problem.

If you need more help on this, please give more details about what you're looking for.
Back to top
View user's profile Send private message
prabs2006

Active User


Joined: 12 Jan 2006
Posts: 103

PostPosted: Tue Mar 21, 2006 1:40 pm    Post subject:
Reply with quote

Hi Frank,

I tried it but somehow Iam not getting the correct result.
The problem is Syncsort is installed in my mainframes. The Job does run correctly but not the result.

My Q is it the problem of not having DFSORT or something elz?\

T & R
Prabs
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Mar 21, 2006 9:13 pm    Post subject:
Reply with quote

The jobs shown in that Smart DFSORT Trick run fine with DFSORT.

I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.
Back to top
View user's profile Send private message
prabs2006

Active User


Joined: 12 Jan 2006
Posts: 103

PostPosted: Tue Mar 21, 2006 9:49 pm    Post subject:
Reply with quote

Thats ok.fine..Thanks a lot
Back to top
View user's profile Send private message
sril.krishy

Active User


Joined: 30 Jul 2005
Posts: 182
Location: hyderabad

PostPosted: Wed Mar 22, 2006 11:59 am    Post subject: Re: Write match & mismatch recs
Reply with quote

Hi,
If your shop is having the latest release of SYNCSORT,You can use the JOIN KEYS feature to get the required o/p files easily.

Please check the SYNCSORT version in your shop.

Thank you
Kris
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Write R1 and R2 to OP1 and R1 to OP2 bhaskar_kanteti DFSORT/ICETOOL 10 Fri Mar 03, 2017 11:18 am
No new posts Can you write 2 recs on SORTOUT when ... Sysaron DFSORT/ICETOOL 6 Thu Feb 23, 2017 12:07 am
No new posts Match records - scdinesh DFSORT/ICETOOL 6 Wed Feb 22, 2017 5:02 am
No new posts JCL sort Match and NoMatch rakeshsekar1987 SYNCSORT 2 Thu Feb 02, 2017 10:26 pm
No new posts For each given key value, how to keep... Div Grad DFSORT/ICETOOL 7 Fri Nov 11, 2016 11:38 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us