Multiple string search using File-AID for PDS members

Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2
tjegan
Posts: 33
Joined: Mon Mar 25, 2013 5:58 pm
Skillset: Mainframe skills
Referer: Chan Lee

Multiple string search using File-AID for PDS members

Postby tjegan » Thu Apr 11, 2013 6:42 pm

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.

pmartyn
Posts: 42
Joined: Thu Feb 28, 2013 7:11 pm
Skillset: COBOL, IMS, CICS, DB2
Referer: Friend

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

Postby pmartyn » Wed May 22, 2013 7:09 pm

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

Code: Select all

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

 

 

rainiraghu
Posts: 1
Joined: Tue Jul 02, 2013 8:22 am
Skillset: mainframe exp
Referer: web access

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

Postby rainiraghu » Tue Jul 02, 2013 8:26 am

what do u mean by sysout=a

NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

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

Postby NicC » Tue Jul 02, 2013 6:08 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic


  • Similar Topics
    Replies
    Views
    Last post