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

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
------------------------------

Original Message:
Sent: 10/16/2022 1:45:00 PM
From: Art Kagel
Subject: RE: SPL Creation Date?

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
------------------------------