SYNCSORT to Add Fields and Create Summary Records

[rcticejr]

I have an analyst on my team that is trying to use syncsort to sum the values from 3 data columns from a file, then add them to create a summary level record when a control break is reached (dealer, part or model changes). Here's a simplified version of the file layout:
dealer
part
model
demand1
demand2
demand3

Add demand 1, 2 and 3 for each line. Add the sum into a summary record that is created for each unique dealer-part-model combination.

Is this possible with syncsort or will it require several syncsoft steps (add columns in 1 step, sum into summary record in a second step)?

[Veera]

Hi rcticejr,

Its possible with ICETOOL,

First let me give my understanding of your requirement and the way i coded based on it,if my understanding is wrong please correct me.

Say we have a input FILEA with the following records

FILEA -> RECS

dealer part model demand1 demand2 demand3
D1 P1 M1 15 15 15
D1 P1 M1 14 14 14
D2 P2 M2 15 15 15
D2 P2 M2 14 14 14

Final Output Desired as per your requirement
********************************************

dealer part model Sum(demand1+ demand2+ demand3) per each key
D1 P1 M1 87
D2 P2 M2 87

Find below the JCL

//TESTSUMX JOB (AAAA,04,T,0000),'SORTT',CLASS=C,MSGCLASS=T,
// NOTIFY=AAAA

/*JOBPARM L=9999
//*
//JOBLIB DD DSN=AAAA.LOAD,DISP=SHR
//*
//STEP01 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//*
//IN1 DD *
D1 P1 M1 15 15 15
D1 P1 M1 14 14 14
D2 P2 M2 15 15 15
D2 P2 M2 14 14 14
//*
//TMP1 DD DSN=AAAA.TEST.TMP1,
// DISP=(MOD,PASS),
// UNIT=SYSDA,
// SPACE=(CYL,(1,2),RLSE),
// DCB=(RECFM=FB,LRECL=11,BLKSIZE=110)
//*
//OUT DD DSN=AAAA.TEST.SPLOUTF,
// DISP=(,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(CYL,(1,2),RLSE),
// DCB=(RECFM=FB,LRECL=11,BLKSIZE=110)
//*
//TOOLIN DD *
COPY FROM(IN1) TO(TMP1) USING(CPY1)
SORT FROM(TMP1) TO(OUT) USING(CPY2)
//CPY1CNTL DD *
OUTFIL FNAMES=TMP1,
BUILD=(1,9,(10,2,ZD,ADD,13,2,ZD,ADD,16,2,ZD),EDIT=(TT),SIGNS=(+,-))
//CPY2CNTL DD *
SORT FIELDS=(1,9,CH,A)
SUM FIELDS=(10,2,CH)

Thanks
Veera.

[rcticejr]

Veera,
Interesting, I have not tried ICETOOL in the past, but this looks like it may be something that could achieve our goal. Thank you for your suggestion!