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
 
Help needed about multiple string search

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

New User


Joined: 26 Mar 2005
Posts: 2

PostPosted: Mon Feb 06, 2006 1:01 pm    Post subject: Help needed about multiple string search
Reply with quote

hi all,
could anyone of you please tell me the way to find out the combination of more than one search string (will not be in the same line) in different lines inside a PDS using the option 3.14 or 3.15? Please find the following example below to understand my question

i want to find out both strings 'ABC' and 'DEF' in any member of a PDS say HLQ.ABCD(*). how to do it?

in the output, i'm expecting only the members having both 'ABC' and 'DEF' present in different lines in a member

Please suggest me the way.
thanks,
sornavel.
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Mon Feb 06, 2006 3:09 pm    Post subject: Re: Help needed about multiple string search
Reply with quote

What the problem you are facing while using 3.15 for the same...

Code:
Command ===>                                                                 
                                                                             
Search DS Name  . . 'HLQ.ABCD'                                           
PDS Member List . . *         (blank/pattern - member list, * - search all)   
                                                                               
(Leave Search DSN "blank" for concatenated-uncataloged-password panel)       
                                                                               
Enter Search Strings and Optional operands (WORD/PREFIX/SUFFIX,C)             
   Caps . .                                                                   
   Caps . . 'ABC'                                                         
   Caps . . 'DEF'                                                       
   Asis . .                                                                   
   Asis . .                                                                   


Regards,

Priyesh.
Back to top
View user's profile Send private message
sornavel

New User


Joined: 26 Mar 2005
Posts: 2

PostPosted: Mon Feb 06, 2006 5:17 pm    Post subject: Re: Help needed about multiple string search
Reply with quote

Priyesh,
thanks for the reply. if i use 3.15 in this manner, it gives me the list of components in the PDS HLQ.ABCE(*) which use either 'ABC' or 'DEF'. but i want the list of components which use 'ABC' AND 'DEF' (ie. similar to logical AND condition). could you please tell me the method of getting the same?

thanks,
sornavel.
Back to top
View user's profile Send private message
yuvaraj80

New User


Joined: 03 Oct 2005
Posts: 10

PostPosted: Wed Feb 08, 2006 6:11 am    Post subject:
Reply with quote

Sornavel,

In ISPF 3.14, you have an option "Specify additional search strings" at the bottom-left corner. Select that option and hit enter, it will throw you another screen where you can enter more than one search string.

Let me know if this did not work.

regards,
Yuvaraj
Back to top
View user's profile Send private message
yuvaraj80

New User


Joined: 03 Oct 2005
Posts: 10

PostPosted: Wed Feb 08, 2006 6:13 am    Post subject:
Reply with quote

I am sorry, my reply is not a solution to your question.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Wed Feb 08, 2006 10:35 am    Post subject:
Reply with quote

There is no built-in option to process your request in SUPERC. The closest statement in SUPERC is SRCHFORC, which looks for additional strings in the same line.

Solutions:
1. Invoke SUPERC for each string individually. Sort and compare the results (member list) where SUPERC found your strings to get a list of matched members.
2. Use REXX, either by invoking SUPERC and comparing the result, or using batch edit macro to FIND the strings.

O.
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 TBSARG - Deleting the search criteria... ISPFHerc TSO/ISPF 1 Thu Dec 14, 2017 8:18 am
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am
No new posts Formatting multiple records to a sing... Vignesh Sid SYNCSORT 3 Tue Nov 07, 2017 12:22 pm
No new posts Updating multiple counts in trailer!! Vignesh Sid SYNCSORT 4 Mon Nov 06, 2017 1:04 pm
No new posts Selecting a row from multiple tables! Vignesh Sid DB2 2 Thu Oct 26, 2017 6:09 pm

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