Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
include records having string more than once

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
venkatesh83be

New User


Joined: 10 Aug 2009
Posts: 12
Location: Chennai

PostPosted: Wed Jul 21, 2010 8:37 am    Post subject:
Reply with quote

Hi All,

Can anyone help me to fetch those records having the search string more than once....

For an instance, if i/p is as below and search string is "@53" -
Code:

78945@5313213468..
12345@531215@53....
111@53111@53111..

o/p should contain only 2nd and 3rd record as "@53" occurs more than once in them.

Thanks,
Venkat.
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Wed Jul 21, 2010 10:28 am    Post subject:
Reply with quote

Hi,

here is a way of achieving this

Code:
//STEP0100 EXEC PGM=SORT                                               
//SYSOUT   DD SYSOUT=*                                                 
//SORTIN   DD *                                                       
78945@5313213468..                                                     
12345@531215@53....                                                   
111@53111@53111                                                       
//GT1      DD SYSOUT=*                                                 
//SYSIN    DD *                                                       
  SORT FIELDS=COPY                                                     
  INREC PARSE=(%=(STARTAT=C'@53'),                                     
              %1=(STARTAT=C'@53',FIXLEN=3)),                           
        OVERLAY=(81:%1)                                               
  OUTFIL FNAMES=GT1,INCLUDE=(81,1,CH,NE,C' '),BUILD=(1,80)             
/*                                                                                                                                       



Gerry
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Wed Jul 21, 2010 11:21 am    Post subject:
Reply with quote

Hi,

Oops icon_redface.gif I just realised my solution is for DFSORT and not SYNCSORT


Gerry
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Wed Jul 21, 2010 6:58 pm    Post subject: Reply to: include records having string more than once
Reply with quote

That solution will work with SyncSort for z/OS 1.3 as well.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Skip records depends on count lakshmiibmmainframes DFSORT/ICETOOL 5 Sun Dec 24, 2017 9:51 pm
No new posts Compare two PS files using ICE TOOL f... SENTHIL MURUGAAN DFSORT/ICETOOL 5 Sun Dec 24, 2017 1:26 pm
No new posts Inefficient BUILD - VB records paddin... Daniel Prosser SYNCSORT 9 Thu Dec 14, 2017 3:52 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us