Skip to Content
Former Member
Apr 09, 2009 at 03:22 PM

Find all tables used in a set of programs


I need to find a list of all tables used in all Z programs. Originally I was thinking of getting a list of programs from table TRDIR, using READ REPORT for each one and then using Regex to get a list of tables used in SQL statements. However getting the regex working appears to be more complicated than first expected so I'm looking for other possibilities.