Merge a variable number of records from a single file

tuxama · New User Joined: 25 Jan 2007 Posts: 42 Location: france

Hello,

As input, a single file which contains for example :

Joerg.Findeisen · Posted: Wed Aug 11, 2021 2:42 am

You can try for example PARSE and a couple of IFTHEN to reformat, but it won't look pretty nor may it be efficient using a SORT product I afraid.

sergeyken · Posted: Wed Aug 11, 2021 7:13 pm

With SORT, the maximum number of elements to be combined into one string is limited to a reasonable value. Usually about 10 elements, theoretically - up to 100. Each new element requires its own reformatting parameter in SORT statements.

Rohit Umarjikar · Posted: Thu Aug 12, 2021 4:20 am

little research could get you similar problems and solutions discussed in past.
Please see these posts to get an idea and give a try. If something doesn’t work then share us the results and someone may help further.
www.ibmmainframeforum.com/syncsort-synctool/topic9154.html
www.ibmmainframeforum.com/syncsort-synctool/topic4000.html

tuxama · New User Joined: 25 Jan 2007 Posts: 42 Location: france

Hello,

Thank you for your time and your answers.
I thought there was no easy fix.

I will do a little rexx it will be simple and easily maintainable.

tuxama.

sergeyken · Posted: Thu Aug 12, 2021 8:12 pm

REXX approach should be OK unless you need to handle millions, or hundreds of millions records. Otherwise you might be faced performance issues.

P.S.
The total number of code needed for REXX solution is not seriously different from SORT solution.