How to write REXX/CLIST to list pgms using a DB2 table

newtorexx · New User Joined: 02 Aug 2006 Posts: 3

My objective is to obtain a list of programs which are accessing a particular table to INSERT or UPDATE or DELETE or SELECT. I think we can write a REXX or CLIST to achieve this. But, I am new to both and needing help. Will appreciate any help.

Thanks!

ofer71 · Posted: Wed Aug 02, 2006 10:46 am

You can do that even with SUPERC.

First, search for the Sstring 'EXEC SQL' (you can ignore COBOL comment lines using DPCBCMT option). Then look for the table name and intersect the results.

O.

antonrino.b · New User Joined: 10 Jan 2006 Posts: 76 Location: Germany

But, When we have the programs in multiple libraries, won't SUPERC take much time to process?

How about using DB2 sysibm tables to get the required pgms?

Thanks,
Antu

newtorexx · New User Joined: 02 Aug 2006 Posts: 3

I am thinking that we have to read/select SYSIBM.SYSPACKDEP and SYSIBM.SYSTABAUTH tables. These tables do have the information. But, do not know how to put the SQL in REXX and CLIST. I just want to use a TSO command something like TSO DB2FIND.

I do not know how to code/compile. Any help will be greatly appreciated.

Thanks

antonrino.b · New User Joined: 10 Jan 2006 Posts: 76 Location: Germany

Hope you can get the required info here...

Thanks,
Antu

newtorexx · New User Joined: 02 Aug 2006 Posts: 3

Thanks Antu. That helped to some extent.