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 

Compare files and add records from file 2 to file 1

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


Joined: 20 Mar 2006
Posts: 133
Topics: 58
PostPosted: Mon Apr 16, 2007 1:01 pm    Post subject: Compare files and add records from file 2 to file 1 Reply with quote
Hi All,

Here's the input file :

Code:


File 1:

abcd11 aaaaaaaaaaaa         9999999999999999
abcd12 bbbbbbbbbbb          8888888888888888
abcd13 cccccccccccccc       7777777777777777

File 2:

abcd14 dadadadadadad        6666666666666666
abcd11 cccccccccccccc       7777777777777777

O/p file

abcd11 aaaaaaaaaaaa         9999999999999999
abcd12 bbbbbbbbbbb          8888888888888888
abcd13 cccccccccccccc       7777777777777777
abcd14 dadadadadadad        6666666666666666




The o/p file will contain all the rec from file 1 and rec from file 2 which are not in file1.

LRECL : 180 bytes , FB file
compare fields:

Pos 4-5 , Pos 7-18 , Pos 26-42

We have syncsort on our shop.

Version of syncsort:

SYNCSORT FOR Z/OS 1.2.1.1R U.S. PATENTS: 4210961, 5117495 (C)
z/OS 1.6.0
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: Mon Apr 16, 2007 1:05 pm    Post subject: Reply with quote
Martin,

Search the forum for JOINKEYS and use those examples

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
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