RE: Stored Routines

Thanks for responding. However, for some reason I could not read your attachement. Also, not familiar with Pearl. Will I be able to easily convert this to a bourne shell script and execute it? Or can I modify it a little for my needs (probably database name and etc.) and just run it in my SGI Unix environment? -----Original Message----- From: Sujit.Pal@bankofamerica.com [mailto:Sujit.Pal@bankofamerica.com] Sent: Thursday, August 19, 1999 9:24 AM To: Cook, Russell L Cc: informix-list@iiug.org Subject: Re: Stored Routines << File: spdeps.pl >> Russell I have a perl script which does this. Its kind of a brute force approach, but it gives a list of column and table dependencies for all your stored procedures. I plan to write a more selective tool later when I get some time. Here it is as a plaintext attachment. HTH Sujit (See attached file: spdeps.pl) "Cook, Russell L" <Russell.Cook@marconi-is.com> on 08/19/99 06:06:12 AM To: "'informix-list@iiug.org'" <informix-list@iiug.org> cc: (bcc: Sujit Pal) Subject: Stored Routines Anyone know a good method to obtain a list of the columns used in all of your stored routines (i.e. both stored procedures and functions)? Is there a system procedure combined with a query that would return this information. Appreciate your help. Thanks in advance. Russell L. Cook Marconi Integrated Systems, Inc (858) 592-5008 russell.cook@Marconi Integrated Systems, Inc