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 

Syncsort Help

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


Joined: 17 Aug 2010
Posts: 1
Topics: 1

PostPosted: Mon Oct 25, 2010 1:19 pm    Post subject: Syncsort Help Reply with quote

I have 2 flat files that are FB, LRECL=80. Both files contain 20 records that look as followed. 1st record starting in col 2 ending col 32. 2nd record staring in col 43 ending in col 65. this format containues for another 8 files. MSTR2 - MSTR9 in both files.
Code:

 DATASET:  BRXTT.TOM.RRR.MSTR0
                                                          TOTAL RECORDS: 28769349
 DATASET:  BRXTT.TOM.RRR.MSTR1
                                                          TOTAL RECORDS: 21769349

The 2nd file follows the same format as the 1st file, but the TOTAL RECORDS will be less in the 2nd file.
Code:

 DATASET:  BRXTT.TOM.RRR.MSTR0
                                                          TOTAL RECORDS: 22000000
 DATASET:  BRXTT.TOM.RRR.MSTR1
                                                          TOTAL RECORDS: 18769349

Is it possible using SYNCSORT to merge the 2 files to get these results?

OUTPUT FILE
EX:
Code:

 DATASET:  BRXTT.TOM.RRR.MSTR0
                                                          TOTAL RECORDS: 28769349
                                                          TOTAL RECORDS: 22000000
                                                                         68769349
DATASET:  BRXTT.TOM.RRR.MSTR1
                                                          TOTAL RECORDS: 21769349
                                                          TOTAL RECORDS: 18769349
                                                                         30000000   

This pattern would follow for files MSTR2 -9

any help is greatly appreciated.
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