When was is inserted ? :)
The poster asked whether Informix can tell when a row was inserted, updated or deleted. Replies said there's no built-in facility by default; options suggested were: insert/update/delete triggers writing to an audit table, creating the table WITH CRCOLS (timestamps last modification only, no insert/delete), adding date/time columns maintained by the application, or digging through the logical logs with onlog/log-snooping tools (a commercial tool, InfoTrace, was also mentioned). The first three need pre-planning and only record going forward; log reading is cryptic and laborious but can cover past transactions. The poster thanked the group; no single chosen solution recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi to All is there a way to know when a row was inserted/updated/delted in a table ? thank's in advance
On 11 March 2011 08:33, SMITH JOHN <daylight@webmails.com> wrote: > Hi to All > > is there a way to know when a row was inserted/updated/delted in a table ? > > thank's in advance > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > John Not by default. Four choices : Create insert, update and delete triggers and write the information to a separate table Create the table WITH CRCOLS which will automatically time-stamp last modification, cannot cope with insert/delete. Add some date/time fields to the table and update them from the application when the record is inserted/updated/pseudo deleted. Use available software to snoop into the logs to find the sql statements. The first three obviously require pre-planning and will only record from this point forward, the last can be cryptic and laborious and can only investigate into the logs that are available but can look at transactions already gone. Keith
thanks a lot
If database is logged, you can find this change in logical log. This is hard-core solution, of course. Hrvoje On 11.03.2011. 09:33, SMITH JOHN wrote: > Hi to All > > is there a way to know when a row was inserted/updated/delted in a table ? > > thank's in advance > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > >
Hi John Please see www.lintel.co.uk/infotrace Regards David Linthwaite Lintel Software Consultancy Ltd IBM Business Partner (www.lintel.co.uk) Tel.: 01244 357250 Fax.: 01244 357248 mailto:dlinthwaite@lintel.co.uk -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SMITH JOHN Sent: 11 March 2011 08:34 To: ids@iiug.org Subject: When was is inserted ? :) [23040] Hi to All is there a way to know when a row was inserted/updated/delted in a table ? thank's in advance **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
You can often find the rows in the "onlog" output - can be a bit tricky to
find which row is being inserted from the output though, unless it has some
identifiable text in the row..
(the rest of the data is binary - so not "immediately" readable)
On 11 March 2011 08:33, SMITH JOHN <daylight@webmails.com> wrote:
> Hi to All
>
> is there a way to know when a row was inserted/updated/delted in a table ?
>
> thank's in advance
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c59ad69db70e049e3894c6