combining several rows

Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

combining several rows

Postby vidyanisha » Fri Feb 01, 2013 12:21 am


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.
Posts: 4
Joined: Tue Jan 29, 2013 10:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: combining several rows

Postby Alissa Margulies » Fri Feb 15, 2013 1:43 am

Hello Vidyanisha.

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

Alissa Margulies
Syncsort Mainframe Product Services
Alissa Margulies
Global moderator
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 2 times

Return to Syncsort/Synctool


  • Related topics
    Last post