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



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

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

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

I'm locking this thread. Please ask Syncsort questions in the appropriate Forum.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

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

 

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

Postby 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
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

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

Postby 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.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 1 time

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

Postby 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:
//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) 
//*     
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 1 time

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post