RE: How to retrive modified records

Kalgaonkar, wrote > > I need to know how to retrive newely added + modified + > deleted records from > specific date. > Is it possible without incremental backup. Even with incremental backup this would not be straightforward because a backup would retrieve deleted records but not get added records or amended. Every table in our database has the following fields, ..... created_by char(8) default user not null , created_dt datetime year to second default current year to second not null , modified_by char(8), modified_dt datetime year to second, This makes everything but the deleted records straightforward. Perhaps you can use a delete trigger for them and archive them somewhere. COlin Bull c.bull@videonetworks.com sending to informix-list