Page 1 of 1

Combine half of the records into 1 row in the output file

PostPosted: Wed Apr 14, 2010 4:19 pm
by Usha Devi.B
Hi All,

I have a requirement to Requirement combine half of the records from input file into 1 ROW in the output file

Input file (FB,LRECL=80):

Krishna
Rama
Durga
Lakshmi
ganesh
Anjaneyalu

Output file(FB,LRECL=160):

I need the output file as below
KrishnaLakshmi
ramaGanesh
LakshmiAnjaneyalu

Can any one suggest the solution for the above requirement.

Thanks
Usha Devi.B

Re: Combine half of the records into 1 row in the output file

PostPosted: Wed Apr 14, 2010 5:12 pm
by Robert Sample
I have a requirement to Requirement combine half of the records from input file into 1 ROW in the output file
Sorry, but this cannot be done. Files on the mainframe have RECORDS, they do not have ROWS. DB2 has ROWS.

Re: Combine half of the records into 1 row in the output file

PostPosted: Wed Apr 14, 2010 6:58 pm
by Usha Devi.B
Hi,
Actually my requirement is

I have an Input file as below.
Input file (FB,LRECL=80):

Krishna
Rama
Durga
Lakshmi
ganesh
Anjaneyalu

Output file(FB,LRECL=160):

I need the output file as below
KrishnaLakshmi
ramaGanesh
LakshmiAnjaneyalu

Can any one suggest the solution for the above requirement.

Thanks&Regards
Usha Devi.B

Re: Combine half of the records into 1 row in the output file

PostPosted: Wed Apr 14, 2010 9:06 pm
by skolusu
usha Devi.B,

Look at the smart DFSORT trick "Combine multiple records into one record" here

http://www.ibm.com/support/docview.wss? ... g3T7000094