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
 
Searching for a text in all DSN

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

New User


Joined: 11 Sep 2007
Posts: 65
Location: Gurgaon

PostPosted: Tue Mar 23, 2010 3:21 am    Post subject: Searching for a text in all DSN
Reply with quote

Hi,

Is there a utility in JCL that will help to search a text in DSNs whereby i only know the upper qualifier...

For example i want to search 'RAJIV' in all DSNs starting from P3453.H5434.**

Of if i can do so on TSO.

Please help me with some JCL if any
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Tue Mar 23, 2010 3:37 am    Post subject: Reply to: Searching for a text in all DSN
Reply with quote

There are plenty of utilities that will search for a string (SORT and SUPERC are two examples) but since you're considering a job you'd have to supply the entire list of datasets for either of them to work with first, most likely by using IDCAMS LISTCAT to show all of the cataloged datasets with that indicated high-level qualifier.
Back to top
View user's profile Send private message
MBabu

Active User


Joined: 03 Aug 2008
Posts: 401
Location: Mumbai

PostPosted: Tue Mar 23, 2010 8:44 am    Post subject:
Reply with quote

If you want to do it in TSO (not JCL), see the SRCHFOR command of the ISPF data set list. It will do this in your ISPF session. Or you can cobble together a small Rexx using the ISPF LMDLIST service (or LISTCAT or 'sys1.samplib(iggcsirx)' ) and SuperC or SORT as Kevin alluded to.
Back to top
View user's profile Send private message
raj_mainframe08

New User


Joined: 11 Sep 2007
Posts: 65
Location: Gurgaon

PostPosted: Tue Mar 23, 2010 5:38 pm    Post subject:
Reply with quote

Thank You MBabu. SRCHFOR works for my requirement.
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 Sorting on text - but in non-alphabet... Roy Ware SYNCSORT 5 Wed Aug 23, 2017 9:15 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
This topic is locked: you cannot edit posts or make replies. Sort card to replace text using cross... Susanta SYNCSORT 32 Tue Sep 13, 2016 4:17 pm
No new posts Only text from varchar Seppe DB2 8 Thu Apr 21, 2016 10:42 pm

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