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 For each given key value, how to keep... Div Grad DFSORT/ICETOOL 7 Fri Nov 11, 2016 11:38 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm
No new posts how to DYNAMICALLY write sort cond to... mohamedmubee COBOL Programming 13 Fri Aug 26, 2016 11:46 pm
No new posts Compare 2 files & write Indicator... nagendrapgupta SYNCSORT 5 Sun May 15, 2016 10:42 am


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