IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need to search all members in one proc library


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mdubey

New User


Joined: 06 Aug 2007
Posts: 5
Location: Hyderabad

PostPosted: Tue Sep 18, 2007 6:04 pm
Reply with quote

Hi,

I have a PS which contains around 3000 file-names. Format of this file is-
FILE.AAAAA
FILE.BBBB.BB
FILE.CCCC.C
(length of file name is not fixed)

I need to search all members in one proc library FILE.PROCLIB, and create another PS which contains file-name as well as all procs which uses this file. Format of output file will be-
FILE.AAAAA PROCA, PROCD
FILE.BBBB.BB PROCB
FILE.CCCC.C PROCC, PROCD, PROCE

I tried using ISRSUPC with PARM=(SRCHCMP,'ANYC'). This is giving me all proc names, but i could not get corresponding proc for each file.
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 128
Location: Guntur

PostPosted: Tue Sep 18, 2007 6:18 pm
Reply with quote

Hi mdubey

Can you post your jcl.
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Tue Sep 18, 2007 11:33 pm
Reply with quote

The SUPERC output would normally look like this:

Code:

PROCA                       --------- STRING(S) FOUND -------------------
                                                                         
     1  //        FILE.AAAAA                                             
                                                                         
PROCB                       --------- STRING(S) FOUND -------------------
                                                                         
     1  //        FILE.BBBB.BB                                           
                                                                         
PROCC                       --------- STRING(S) FOUND -------------------
                                                                         
     1  //        FILE.CCCC.C                                             
                                                                         
PROCD                       --------- STRING(S) FOUND -------------------
                                                                         
     1  //        FILE.AAAAA                                             
     2  //        FILE.CCCC.C                                             
                                                                         
PROCE                       --------- STRING(S) FOUND -------------------
                                                                         
     1  //        FILE.CCCC.C         


Doesn't that, with some editing, give you what you need?
Back to top
View user's profile Send private message
mdubey

New User


Joined: 06 Aug 2007
Posts: 5
Location: Hyderabad

PostPosted: Wed Sep 19, 2007 11:10 am
Reply with quote

Hi balakrishna,
Here is my JCL
Code:

//SEARCH  EXEC PGM=ISRSUPC,                       
//            PARM=(SRCHCMP,'ANYC')               
//NEWDD  DD DSN=PROD.PROCLIB,DISP=SHR     
//OUTDD  DD SYSOUT=(A)                             
//SYSIN  DD DSN=INFILE.FILELIST,DISP=SHR                                     

Where INFILE.FILELIST contains-
SRCHFOR 'FILE.AAAAA'
SRCHFOR 'FILE.BBBB.BB'
SRCHFOR 'FILE.CCCC.C'
.
.


Superk,
my plan to solve this problem was to get a list which contains proc name with corresponding file name. So that i can give this result in Ezt and get the required format of output file. The result which i'm getting from this jcl is difficult to use in Ezt as there are many files which are being used in more than 8 procs. Even file names are 3000+, so it will be diffcult to collect all proc names for particular file. I was searching for some other PARM which can be used with ISRSUPC so that i can get filename and proc name at the same line. Or result is the other way, like -
Code:

FILE.AAAAA           PROCA
FILE.BBBB.BB        PROCB
FILE.CCCC.C         PROCC
FILE.AAAAA           PROCD
FILE.CCCC.C         PROCD
FILE.CCCC.C         PROCE

It will be helpful if i'm getting result in filename -> proc name format

Please suggest if there is any other possible way to do that.
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Sep 21, 2007 2:14 am
Reply with quote

I'm thinking a good way to do what you want might be to add the member name, presumably to the end, of each record you're searching for, and convert the PDS to a sequential dataset. That way, every hit with SUPERC would look more like:

Code:

     1 //DD1 DSN=FILE.AAAAA   PROCA                         
     3 //DD1 DSN=FILE.BBBB.BB PROCB                         
     6 //DD1 DSN=FILE.CCCC.C  PROCC                         
     7 //DD1 DSN=FILE.AAAAA   PROCD                         
     8 //DD2 DSN=FILE.CCCC.C  PROCD                         
    10 //DD1 DSN=FILE.CCCC.C  PROCE                         
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 128
Location: Guntur

PostPosted: Fri Sep 21, 2007 5:00 pm
Reply with quote

Hi mdubey,

Code:

SRCHFOR 'FILE.AAAAA'
SRCHFOR 'FILE.BBBB.BB'
SRCHFOR 'FILE.CCCC.C'


As you mentioned the file list you want to search, Do a little modification to it like add one more search string with 'proc' and submit the job.

Code:

SRCHFOR 'FILE.AAAAA'
SRCHFOR 'FILE.BBBB.BB'
SRCHFOR 'FILE.CCCC.C'
SRCHFOR 'PROC'


now you will get the file name along with the proc name, after getting output you can edit the data you don't require.

for editing the data if you need any help please post some part of the output.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Search two or more word with FILEAID Compuware & Other Tools 15
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts Calling an Open C library function in... CICS 1
No new posts first column truncated in search result IBM Tools 13
No new posts Submit multiple jobs from a library t... JCL & VSAM 14
Search our Forums:

Back to Top