SPL Creation Date?

Posted in 2022

David Grove — source: IBM Community (ConnectedCommunity.org) Informix forum

Informix 12.10.FC14 Solaris 10 1/13 How can one determine the creation date (or last modified date) for a stored procedure? I have looked at what I thought were likely tables in the system catalog, but, haven't found that information, yet. Thank you. Regards, DG ------------------------------ David Grove ------------------------------ #Informix

↪ replying to David Grove

Art Kagel — source: IBM Community (ConnectedCommunity.org) Informix forum

David: Unless it is encoded in one of the datakey type records in sysprocbody, I don't think the create date/time nor the last compile time is stored where we can get at it. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------

↪ replying to Art Kagel

Paul Watson — source: IBM Community (ConnectedCommunity.org) Informix forum

You can also add the 'document' bit Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark of Oninit LLC