IBM Mainframe Forum

by **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 ??

by **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

by **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.

by **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.

by **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'.

Select all

//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'.

Select all

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

Arun.

IBM Mainframe Forum

How to Search multiple strings using AND logic

How to Search multiple strings using AND logic

Re: How to Search multiple strings using AND logic

Re: How to Search multiple strings using AND logic

Re: How to Search multiple strings using AND logic

Re: How to Search multiple strings using AND logic