IBM Mainframe Forum

by **Usha Devi.B** » Wed Apr 14, 2010 4:19 pm

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

by **Robert Sample** » Wed Apr 14, 2010 5:12 pm

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.

by **Usha Devi.B** » Wed Apr 14, 2010 6:58 pm

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

by **skolusu** » Wed Apr 14, 2010 9:06 pm

usha Devi.B,

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

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

IBM Mainframe Forum

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

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

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

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

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