IBM Mainframe Forum

by **Frank Yaeger** » Fri Feb 19, 2010 10:31 pm

I'm locking this thread. Please ask Syncsort questions in the appropriate Forum.

by **dick scherrer** » Sat Feb 20, 2010 12:36 am

Hello,

Topic re-located and unlocked for Syncsort info.

I am using SYNCSORT FOR Z/OS 1.2.3.1R.

Unfortunately, this is not the current release.

d

by **Alissa Margulies** » Sat Feb 20, 2010 12:41 am

WHEN=GROUP is supported in SyncSort for z/OS 1.3.2. You are running an older version of SyncSort which does not contain this support. I will work on an alternate solution for you.

by **Alissa Margulies** » Sat Feb 20, 2010 1:05 am

Based on your sample input data, here is a SyncSort for z/OS 1.2 job that will produce your requested output:

Select all

//S1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DISP=SHR,DSN=YOUR.VB.INPUT
//SORTOUT DD SYSOUT=*
//SYSIN DD *
INCLUDE COND=(5,3,SS,EQ,C'HDR,TRL')
INREC IFTHEN=(WHEN=INIT,BUILD=(1,4,C'1',5,11)),
IFTHEN=(WHEN=(6,3,CH,EQ,C'HDR'),BUILD=(1,4,5,1,9,8,6Z)),
IFTHEN=(WHEN=(6,3,CH,EQ,C'TRL'),BUILD=(1,4,5,1,8Z,9,6))
SORT FIELDS=(5,1,CH,A)
SUM FIELDS=(6,4,BI,10,4,BI,14,4,BI,18,2,BI)
OUTREC FIELDS=(1,4,6)
//*

IBM Mainframe Forum

Syncsort/DFSORT to omit otherlines ( including HDR and TRL )

Re: DFSORT to omit the otherlines ( including HDR and TRL )

Re: Syncsort/DFSORT to omit otherlines ( including HDR and TRL )

Re: Syncsort/DFSORT to omit otherlines ( including HDR and TRL )

Re: Syncsort/DFSORT to omit otherlines ( including HDR and TRL )