IBM Mainframe Forum

Posted: **Tue Jan 29, 2013 11:10 pm**

Hi,

I have an input file of LRECL=50 in the following format.

DB1 20 FormA
DB2 10 FormA
DB6 15 FormB
DB3 60 FormA
DB7 80 FormC
in this way 1 to 8 records for each form type.

I need the o/p with LRECL=120 in the below format
Form-Type DB1 DB2 DB3 DB4 DB5 DB6 DB7 DB8
FormA 20 10 60
FormB 15
FormC 80

Can any one please let me know how to do this using syncsort.I cant use ifthen=(when=(group as it is not supported .

Posted: **Tue Jan 29, 2013 11:17 pm**

sorry..i forgot to mention that the output format should be the count for each form type under the specific DB number.
ie
FormType DB1 DB2 DB3 DB4 DB5 DB6 DB7 DB8
FormA
FormB
FormC

in a tabular format.

Posted: **Tue Jan 29, 2013 11:48 pm**

Obviously, you did not read the rules, as rule #1 is:

Topics must be submitted to the relevant forums.

Posted: **Thu Jan 31, 2013 6:58 pm**

sorry for the trouble

IBM Mainframe Forum

combine multiple records into a single one using syncsort

combine multiple records into a single one using syncsort

Re: combine multiple records into a single one using syncsor

Re: combine multiple records into a single one using syncsor

Re: combine multiple records into a single one using syncsor