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



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

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

Postby 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
Usha Devi.B
 
Posts: 2
Joined: Wed Apr 14, 2010 3:51 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby 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.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

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

Postby 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
Usha Devi.B
 
Posts: 2
Joined: Wed Apr 14, 2010 3:51 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby 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
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post