How to retrive modified records

I need to know how to retrive newely added + modified + deleted records from specific date. Is it possible without incremental backup. Thanks Ruturaj Kirloskar Copeland Ltd, Karad This message (including any attachments) contains confidential Information intended for a specific individual recipient and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. sending to informix-list

On Fri, 01 Aug 2003 08:18:54 -0400, Kalgaonkar, Ruturaj S. wrote: Only by parsing through the logical logs and that's no easy thing. If you have this need you should add a timestamp column to all critical tables and have a DEFAULT clause set the value on insert and a FOR UPDATE trigger maintain that timestamp (or perhaps separate CREATED and UPDATED stamps). Art S. Kagel > I need to know how to retrive newely added + modified + deleted records > from specific date. > Is it possible without incremental backup. Thanks Ruturaj Kirloskar > Copeland Ltd, > Karad