MVSFORUMS.com

mgjagadish · Posted: Sat May 10, 2003 10:10 am Post subject: To develop a rexx tool

Hi Rexx Pals,
I would like to have some constructive ideas basically to track the Most and
least DB2 table used in a Endevor Cobol Source Library..Like I have some
ideas but not sure to put in shape.Write an rexx routine to find the least and most occuring DB2 Tables.. in the COBOL Library.I use an rexx macro('EL) to read the library.
It would be helpful if some would provide me with an algorithm.

Bye,
Take Care,
Jagadish
_________________
JAGADISH

sriramla · Beginner Joined: 22 Feb 2003 Posts: 74 Topics: 1

Apart from writing a rexx routine, you can also look into SYSIBM.SYSPACKDEP and other SYSIBM.SYSPACK% tables. These tables store info regarding the list of tables and columns used by programs. You can query these tables to get what you are looking for - The usage of tables.

Sorry I'm not giving the algorithm/Query as you are looking for. Just trying to give directions where you can explore more.

mgjagadish · Posted: Mon May 12, 2003 10:16 am Post subject:

Sriramla,
Thank you very much...
_________________
JAGADISH