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