MVSFORUMS.com

[sushma4satya]

I have a 2 input files of LRECL =200
Merged out file with header : LRECL = 200

File : 1

HDR20060214
AAAAAAA
BBBBBBB
CCCCCC
TRL20060214000003


File : 2

HDR20060214
DDDDD
EEEEEE
FFFFFFF
TRL20060214000003

I want to merge the above 2 files like below, which should have header as below.

HDR20060214
AAAAAAA
BBBBBBB
CCCCCC
DDDDD
EEEEEE
FFFFFFF

Please let me know any simple solution by using either SORT or ICETOOL or SYNSORT.

Thanks

[kolusu]

sushma4satya,

Do you need the header from file1? or can it be created dynamically ? i.e

HDR followed by current date for header ?

Do you want to sort the file based on the key ? (AAAAAA ...). If so what is the length and position of the key?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[sushma4satya]

Thanks Kolusu for immediate reply

1. I need HDR followed by current date for header
2. I don't want to sort the file.

[kolusu]

sushma4satya,

Try this

[sushma4satya]

Thanks Kolusu,its working perfectly .

Iam curious to learn about :

OMIT COND=(1,3,SS,EQ,C'HDR,TRL')
SORT FIELDS=COPY
OUTFIL REMOVECC,
HEADER1=(C'HDR',DATENS=(4MD))

Could you please explain in detail or if you provide some document it would be helpful to me.

Thanks

[Frank Yaeger]

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort