Re: Table last updated time.

} 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 } >There are only 2 approaches I can think of, and they are both extremely hard ! 1. Each Tblspace Tblspace page has a page timestamp. IF this is altered at the same time as your table is updated, then that will hold the info you need. I doubt this is true though. 2. Each Data Page has a page timestamp which is updated when the page is modified in any way. This could be the answer. The challenge is to get all the pages for the table concerned, access these timestamps and work out which is the most recent. That I have no ideas on ! Anyone else ?? Good luck, Rick Ward