MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Delta file extraction thru sync sort

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
mahesh_chv
Beginner


Joined: 04 Aug 2005
Posts: 41
Topics: 16

PostPosted: Fri Oct 31, 2008 4:43 am    Post subject: Delta file extraction thru sync sort Reply with quote

Hi ,

I have a requirement , where in , I need to compare two files and write an output file excluding the common records in both the files (ie ) delta .

Can we achieve this using Sync sort ??
If so , can you please post the JCL

Thanks,
Mahesh
Back to top
View user's profile Send private message
amargulies
Beginner


Joined: 10 Jan 2007
Posts: 123
Topics: 0

PostPosted: Fri Oct 31, 2008 11:35 am    Post subject: Reply with quote

You can use SyncSort's JOIN feature to accomplish this task. What are the RECFM and LRECL of the files?
_________________
Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Back to top
View user's profile Send private message Send e-mail
mahesh_chv
Beginner


Joined: 04 Aug 2005
Posts: 41
Topics: 16

PostPosted: Sun Nov 02, 2008 11:25 pm    Post subject: Reply with quote

Hi Alissa margulies,

The RECFM is VB and LRECL is 43 .
Can you please post the code over here .

Thanks,
Mahesh
Back to top
View user's profile Send private message
mahesh_chv
Beginner


Joined: 04 Aug 2005
Posts: 41
Topics: 16

PostPosted: Mon Nov 03, 2008 12:11 am    Post subject: Reply with quote

Hi Allissa Margulies,

I am able to achieve my task using the Join feature of SyncSort.
Thank you very much Very Happy


Mahesh
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group