How to create single record from multiple files ?
Posted:
Wed Jul 05, 2017 11:04 pmby vinayjai
I have 5 different files with same record length. Each files are having only one record. I need to pick certain position values from files 1 to 5 and create a final file with one single record . How do i achieve this using DFSORT?
Re: How to create single record from multiple files ?
Posted:
Thu Jul 06, 2017 10:30 amby Aki88
Hello,
Questions:
a. Is the data content in all datasets similar/same or different?
b. Can you please show what you want with representational data?
Aside; if all the datasets are QSAM AND are RECFM=FB, DD concatenate them into a single input DD card; use ICETOOL RESIZE operator to bring these into a single row. Since all the input datasets have only 1 record, hence the final RESIZEd length will come to: (LRECL of 1 DS * 5)
Now in the same step, post process the data using OUTFIL/OUTREC to cull out only the fields you need.