Page 2 of 2

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

PostPosted: Fri Feb 19, 2010 10:31 pm
by Frank Yaeger
I'm locking this thread. Please ask Syncsort questions in the appropriate Forum.

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

PostPosted: Sat Feb 20, 2010 12:36 am
by dick scherrer
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

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

PostPosted: Sat Feb 20, 2010 12:41 am
by Alissa Margulies
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.

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

PostPosted: Sat Feb 20, 2010 1:05 am
by Alissa Margulies
Based on your sample input data, here is a SyncSort for z/OS 1.2 job that will produce your requested output:
//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) 
//*