SPL Creation/Modified Date?

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@gmail.com> wrote: > 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 > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >