Accumalation of records

sahil mohta · New User Joined: 25 Jul 2008 Posts: 5 Location: pune

hiii,

i have to accumalate the records present in my file like :-

1 hi mike
1 hello ravi
2 hi bob
3 hi pop
2 yes luv

and i want the output as :-

1 hihello mikeravi
2 hiyes bobluv
3 hi pop

i think this can be done by the DFSORT but how that i dont know.
and if there is any other means to solve this problem than please tell me.

thanks & regards.

krisprems · Posted: Tue Jul 29, 2008 6:20 pm

check DFSORT trick book=> Use [URL] BBCode for External Links
for the topics "Join fields from two files on a key" and "Join fields from two files record-by-record"

dick scherrer · Posted: Tue Jul 29, 2008 9:53 pm

Hello,

I see no "2 files"

Frank Yaeger · Posted: Tue Jul 29, 2008 9:58 pm

Sahil Mohta,

Yes, you can do this with DFSORT/ICETOOL. But you need to supply more information before I can show you how.

Please tell me the starting position and length of each field in your input records, and the starting position and length of each field in your output records.

I assume the first field is the key - can you only have one or two instances of the same key (e.g. 1) or can you have more than two instances? If you can have more than two instances, show an example of the input and output records for that. Please use BBCODE code tags for examples.

Also, what is the RECFM and LRECL of your input file?