I have an input file of LRECL=50 in the following format.
DB1 20 typeA
DB2 10 typeA
DB6 15 typeB
DB3 60 typeA
DB7 80 typeC
in this way 1 to 8 records for each form type.
I need the o/p with LRECL=120 in the below format as a table with DB count corresponding to each type
Type DB1 DB2 DB3 DB4 DB5 DB6 DB7 DB8
typeA 20 10 60
Can any one please let me know how to do this using syncsort.I cant use ifthen=(when=(group as it is not supported .
I tried this with sum fields in the binary format. but i am not getting it in the required format.