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 

Comparing key in 2 files and extract the matched & unmat

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


Joined: 25 Aug 2006
Posts: 10
Topics: 5

PostPosted: Tue Sep 19, 2006 8:59 am    Post subject: Comparing key in 2 files and extract the matched & unmat Reply with quote

HI,

I have the requirement to compare data at different positions of two files write the matched data in files and unmatched data in another files.

both are fixed length files of lRECL of file1 is 80 and lrecl of file2 is 200

FILE1 20:8
FILE2 1:8

for the matched records
FILE1 (20:8) SHOULD BE COMPARED WITH FILE2 (1:8) AND IF MATCHES WRITE IN outFILE3 and
matched records from file1 to outfile1
matched records from file2 to outfile2

for the unmatched records
records from file1 to outfile4 and unmatched records from file2 to outFILE5.

I wanted to achieve this in easytriev or using syncsort

Can anybody help me achieve this

Thanks in advance
Srinu
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Tue Sep 19, 2006 9:10 am    Post subject: Reply with quote

srinu14165,

Please search before posting . Check these links


http://www.mvsforums.com/helpboards/viewtopic.php?t=11&highlight=match

http://www.mvsforums.com/helpboards/viewtopic.php?t=5399

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
srinu14165
Beginner


Joined: 25 Aug 2006
Posts: 10
Topics: 5

PostPosted: Wed Sep 20, 2006 10:23 am    Post subject: Sorry my mistake Reply with quote

I apologise,
I should have searched before posting.

Thanks much Kolusu


Srinu
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