Re: Q: Stored procedures and table dependency

william_riedy@fac.com wrote: > > OK all of you Informix guru's out there, I have a tough question for you! > > How can I programatically (via SQL preferably) determine the tables > and/or views that a stored procedure references. From memory MS SQL and > Oracle both track dependencies in the database catalog in somewhat human > readable format. Informix does store the information but it appears to be > encoded or compiled. > > I know that I can reverse engineer all sp's via the dbschema command but > then I would have to write a wicked parser in C or another tool to > determine that stored procedure "S" needs table "T" and view "V". Personally I use a script but there again I like scripting 'cos I'm sad. It's straightforward, get each procedure and look for any SQL and retrieve the tables etc. -- Paul Watson WF Software Ltd Tel: +44 1436 674629 Fax: +44 1436 678693 www.wfsoftware.co.uk