Re: Table last updated time.

Posted in 1996

Joseph Kormann — Mon, 25 Nov 96 04:01:55 GMT — source: Informix-list mailing list archive (1991-1998)

In article <575cl8$n12@cssun.mathcs.emory.edu>, "26#e#Susik_Lee_at_United#u#Group#c##c#25#e#PC_CCMail"@MAIL.FABRIK.COM (=?US-ASCII?Q?Susik_Lee?=) wrote: > Hi, > > Can anyone tell me if Online 7.10.UC5 or 7.12.UC2 has function >where > you can find out last time table was updated? Do you know any >one of > sys tables has table updated time? > > > Thanks > > > Suisk > > susik.lee@uica.com > Are you talking about the last time you ran UPDATE STATISTICS or the last time that you added something to the table? For UPDATE STATISTICS, I really have no clue. For the other one, may looking at the time-stamp on the record it self (it works sometimes in Unix). -Joseph