last time a table was update

I would like to know if there is an informix command that could tell me when was the last update/insert/delete on a specific table. I do not want to use triggers. I am looking something with oncheck, onstat or any other command ? Informix IDS 7.30.FC7 on DIGITAL UNIX OSF1 PFA6 V4.0 1091 alpha Thanks Francois

Martine Pelletier wrote: > > I would like to know if there is an informix command that could tell me when > was the last update/insert/delete on a specific table. I do not want to use > triggers. > > I am looking something with oncheck, onstat or any other command ? > > Informix IDS 7.30.FC7 on > DIGITAL UNIX OSF1 PFA6 V4.0 1091 alpha The only way is to use a trigger to log the transaction. You COULD use onlog (only on closed logfiles don't use it on the current log) to report the logical log records and look for the table's partnum(s). Last Resort. Art S. Kagel