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

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.
tjegan
 
Posts: 33
Joined: Mon Mar 25, 2013 5:58 pm
Has thanked: 0 time
Been thanked: 0 time

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

 

 
pmartyn
 
Posts: 42
Joined: Thu Feb 28, 2013 7:11 pm
Has thanked: 5 times
Been thanked: 3 times

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
rainiraghu
 
Posts: 1
Joined: Tue Jul 02, 2013 8:22 am
Has thanked: 0 time
Been thanked: 0 time

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
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post