Re: How do I find out the last time a table has been changed (not metadata).

Posted in 2012

malc_p — Tue, 17 Jul 2012 10:44:34 +0100 — source: Usenet: comp.databases.informix

You could parse the output from the onlog -n -t<tblspace number> for HUPDATE, HINSERT, HDELETE entries...the Administrator's ref manual gives info on the relevant field values On 16/07/2012 16:36, Todd Roy wrote: > Hi all, > I'm sorry if this is a faq somewhere but I have a developer who > wants to know the last update/insert/delete > date of an arbitrary (ie any) table in a database. > > Thanks, > Todd > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list