How to create single record from multiple files ?

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

How to create single record from multiple files ?

Postby vinayjai » Wed Jul 05, 2017 11:04 pm

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?
Posts: 3
Joined: Thu Jun 22, 2017 10:16 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to create single record from multiple files ?

Postby Aki88 » Thu Jul 06, 2017 10:30 am


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.
Posts: 381
Joined: Tue Jan 28, 2014 1:52 pm
Has thanked: 33 times
Been thanked: 36 times



  • Related topics
    Last post