Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  SPL Creation Date?

    Posted Fri October 14, 2022 06:33 PM
    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


  • 2.  RE: SPL Creation Date?

    Posted Sun October 16, 2022 01:45 PM
    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


  • 3.  RE: SPL Creation Date?

    Posted Sun October 16, 2022 02:23 PM
    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



    Original Message


Related Content