How to Search multiple strings using AND logic



Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2

How to Search multiple strings using AND logic

Postby prashanthreddy » Sat Mar 15, 2008 5:31 pm

I would like to search the members in a PDS by entering more than one string using AND logic. we have ISPF search panel but it is searching using OR logic. how can i do that ?? Is there any utilities or tools to do that ??
prashanthreddy
 
Posts: 8
Joined: Sat Jan 19, 2008 3:19 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to Search multiple strings using AND logic

Postby arunprasad.k » Sat Mar 15, 2008 5:55 pm

What do you want to do after you search?? Do you want to display/select a line that has both the strings??

Or you just want the member name which has both the strings?? :?

Please post some sample input and output, this would be helpful for those who would like to help you. Arun
arunprasad.k
 
Posts: 110
Joined: Thu Dec 27, 2007 5:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to Search multiple strings using AND logic

Postby prashanthreddy » Sat Mar 15, 2008 6:56 pm

sorry for not giving complete details. I would like to display the member names along with the lines .

for example if I enter any particular field in one table, select and the table name then it should give all the members list which are using tht particular field in select Query from that table only.
prashanthreddy
 
Posts: 8
Joined: Sat Jan 19, 2008 3:19 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to Search multiple strings using AND logic

Postby arunprasad.k » Tue Mar 18, 2008 10:04 pm

for example if I enter any particular field in one table, select and the table name then it should give all the members list which are using tht particular field in select Query from that table only.


You give 'SELECT', 'FIELD1', and 'TABLE1' as inputs and you want to search the source module or DBRM lib to get all the program names which uses FIELD1 from TABLE1 in SELECT statement :?:

This looks like a tool :roll:. We can not do this with just a search using FileAid or ISRSUPC. If we do this with just a search we might end up getting erroneous results.

Post if I misunderstood your requirement.

Arun.
arunprasad.k
 
Posts: 110
Joined: Thu Dec 27, 2007 5:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to Search multiple strings using AND logic

Postby arunprasad.k » Tue Mar 18, 2008 10:25 pm

Use this JCL to list the line and the member name which has the characters ' JOB ' and 'NOTIFY'.

//FASTEP   EXEC PGM=FILEAID,REGION=6M                 
//STEPLIB  DD  DISP=SHR,DSN=SYS3.FILEAID.LOAD         
//SYSPRINT DD  SYSOUT=*                               
//SYSLIST  DD  SYSOUT=*                               
//DD01     DD  DISP=SHR,DSN=YOUR.PDS.NAME
//SYSIN    DD  *                                       
$$DD01 DUMP IF=(01,0,C' JOB '),                       
           AND=(01,0,C'NOTIFY')                       
/*   


Use this SYSIN if you want all the lines of the member and the name which has the characters ' JOB ' or 'NOTIFY'.

$$DD01 LISTMEM F=JCL,IF=(1,0,C' JOB '),IF=(1,0,C'NOTIFY')


Arun.
arunprasad.k
 
Posts: 110
Joined: Thu Dec 27, 2007 5:18 pm
Has thanked: 0 time
Been thanked: 0 time


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post