I have created a similar rule once, which will tell you all the tables and temp-tables being used in given program. Even if you have defined a buffer for the table with a different name, it will give you the actual name of that table. Sadly i am not having a copy of that program right now, but i can give you an idea on how to write one -
I have used existing rule tableusage (http://www.oehive.org/prolint/rules/tableusage) and created a new program for my rule and then used the XREF information to find out temp-tables and db tables.
hope this helps.
I'll write that code again and post after some time.
Comments
#1
I have created a similar rule once, which will tell you all the tables and temp-tables being used in given program. Even if you have defined a buffer for the table with a different name, it will give you the actual name of that table. Sadly i am not having a copy of that program right now, but i can give you an idea on how to write one -
I have used existing rule tableusage (http://www.oehive.org/prolint/rules/tableusage) and created a new program for my rule and then used the XREF information to find out temp-tables and db tables.
hope this helps.
I'll write that code again and post after some time.
--
Ganesh