RAYNGERFAN Beginner
Joined: 17 Aug 2010 Posts: 1 Topics: 1
|
Posted: Mon Oct 25, 2010 1:19 pm Post subject: Syncsort Help |
|
|
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. |
|