Page 1 of 1

Multiple string search using File-AID for PDS members

PostPosted: Thu Apr 11, 2013 6:42 pm
by tjegan
Hi ,
I want to find the list of members that contains the strings delete and TableA.

Ex:
MEM1
DELETE from
TableA

MEM2:
Select *
from
TableA

For this case, MEM1 should be displayed in the SPOOL. Can anyone please give me the suggesstion to code using FILE-AID or ISRSUPC or PDSMAN.

Thanks in Advance.

Re: Multiple string search using File-AID for PDS members

PostPosted: Wed May 22, 2013 7:09 pm
by pmartyn
I would love to but Enrico has already done that. Here is the link jcl/topic5763.html

His example is excellent showing the output from the run etc. . . In case you are in a hurry here is some 'generic' JCL to do fulfill your requirement
//SRCHFOR JOB (,,time,lines),'your name',CLASS=class
/*ROUTE  PRINT node.location
// EXEC PGM=ISRSUPC,
//      PARM=(SRCHCMP,ANYC,IDPFX,NOPRTCC)
//NEWDD DD DSN=your.data.set.name,DISP=OLD
//OUTDD DD SYSOUT=A
//SYSIN DD *
 SRCHFOR  'string1'
 SRCHFOR  'string2'
 SRCHFORC 'and string3'
//*end
/*

 

 

Re: Multiple string search using File-AID for PDS members

PostPosted: Tue Jul 02, 2013 8:26 am
by rainiraghu
what do u mean by sysout=a

Re: Multiple string search using File-AID for PDS members

PostPosted: Tue Jul 02, 2013 6:08 pm
by NicC
what do u mean by sysout=a

The word is 'you' not 'u'
If you so not know this basic JCL then I suggest you look up the JCL Language Reference and User Guide manuals easily got to by following the IBM Manuals links at top and bottom of each page of the forum. Note that the A is installation specific but generally will be acceptable.