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
 
Search String - Starting location of the string unknown

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

New User


Joined: 02 May 2006
Posts: 25

PostPosted: Fri Apr 25, 2008 2:22 am    Post subject: Search String - Starting location of the string unknown
Reply with quote

Hello All,

I have a 5000 byte file. It has fillers starting from 3220 bytes till end. I need to search for those records which has a particular string 'XXXXX' at any location between 3220 and 5000 bytes. How can I do this using a JCL. Since the starting location of the strin is not know I cant use Syncsort.
Back to top
View user's profile Send private message

Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Fri Apr 25, 2008 2:37 am    Post subject: Re: Search String - Starting location of the string unknown
Reply with quote

ranjanp wrote:
...at any location between 3220 and 5000 bytes. ... Since the starting location of the strin is not know I cant use Syncsort.

Why can't you use SyncSort? Are you familiar with Substring Comparisons?
Back to top
View user's profile Send private message
ranjanp

New User


Joined: 02 May 2006
Posts: 25

PostPosted: Fri Apr 25, 2008 2:41 am    Post subject: Re: Search String - Starting location of the string unknown
Reply with quote

Alissa Margulies wrote:
ranjanp wrote:
...at any location between 3220 and 5000 bytes. ... Since the starting location of the strin is not know I cant use Syncsort.

Why can't you use SyncSort? Are you familiar with Substring Comparisons?


No. I am not familiar with this.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Fri Apr 25, 2008 2:55 am    Post subject:
Reply with quote

Try the following:
Code:
//SYSIN DD *
    SORT FIELDS=COPY
    INCLUDE COND=(3220,2780,SS,EQ,C'XXXXX')
/*
Back to top
View user's profile Send private message
ranjanp

New User


Joined: 02 May 2006
Posts: 25

PostPosted: Sat Apr 26, 2008 11:38 am    Post subject:
Reply with quote

Thanks alot Alissa. It worked...
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 line 52: Name or string > 250 char... Ashishpanpaliya CLIST & REXX 5 Sat Oct 14, 2017 2:29 am
No new posts HEX value search in a DB2 query maxsubrat DB2 2 Wed Oct 04, 2017 3:04 pm
No new posts Search for a string in many PDS KARTHIGADEVI CLIST & REXX 5 Fri Sep 08, 2017 2:32 pm
No new posts How to change a string containing the... chong.zhou TSO/ISPF 6 Tue Aug 29, 2017 4:54 pm
No new posts String after '.' (period) is not copy... balaji81_k SYNCSORT 6 Wed Aug 23, 2017 9:35 pm

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