My boss just told me he wants to know the most recent modified date
for each stored procedure in our database. I have to admit: 1) I was
never asked that before; 2) I don't know how to find that information.

My first thought was to use the plan date in sysprocplan, but that
doesn't work because we regularly Update Stats.

How can I find the most recently modified date for each SPL?

Thank you.

DG

Unless you had auditing turned on when you created and updated your
procedures and functions, you cannot do it. Your stored procedure source
code should be in a source control system just like all of your other code
is! There you would have your change history and dates.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.



On Tue, Nov 8, 2011 at 3:27 PM, pretzel <davidegrove (AT) gmail (DOT) com> wrote: