Page 1 of 1

combining several rows

PostPosted: Fri Feb 01, 2013 12:21 am
by vidyanisha
Hi,

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
typeB 15
typeC 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 .
I tried this with sum fields in the binary format. but i am not getting it in the required format.

Re: combining several rows

PostPosted: Fri Feb 15, 2013 1:43 am
by Alissa Margulies
Hello Vidyanisha.

IFTHEN=(WHEN=GROUP... has been supported since SyncSort for z/OS 1.3.2.0, which was GA in January 2009. What release of Syncsort are you running?

Regards,