how to get last update of a record in a table
User on IDS 9.4 asked how to find when a table was last modified — first meaning the last insert/update/delete on a row, then clarifying he wanted the date of the last schema change (column added or dropped). Answers: for row-level timestamps, Informix doesn't track this unless you maintain it yourself via application code or triggers, or create the table WITH AUDIT/WITH CRCOLS. A suggestion to use systables.created was rejected, since 'created' isn't updated by in-place ALTERs. The only remaining source is the logical logs, which can be scanned with onlog or more readably with the infotrace tool. No single clean solution emerged.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi All, Just want to ask if I can get the "last update/insert/delete" of a record in a certain table? thanks
btw, i'm using IDS 9.4
Please disregard the question earlier... I am referring to "if i can get the last change on the table schema".. i mean, the date if a column is deleted or added.
SELECT created FROM systables WHERE tabname = ?
Regards,
Doug Lawry
Only if you are maintaining it yourself (application code or triggers) or have added one of the WITH options to the table that maintain that time such as WITH AUDIT or WITH CRCOLS. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Apr 17, 2012 at 2:40 AM, JACK PAPA <informix2009@gmail.com> wrote: > Hi All, > > Just want to ask if I can get the "last update/insert/delete" of a record > in a > certain table? > > thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f3ba959dc8ee004bddd240c
That information is in the logical logs. You could poke around in there
going backwards until you find something. David Linthwait has a package,
infotrace (http://www.lintel.co.uk/infotrace/index.php) that can parse and
display logical log information in a more useful form than onlog.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, Apr 17, 2012 at 3:04 AM, JACK PAPA <informix2009@gmail.com> wrote:
> Please disregard the question earlier...
>
> I am referring to "if i can get the last change on the table schema".. i
> mean,
> the date if a column is deleted or added.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3ba75f488ea704bddd5101
Nope. Created is never updated. Certain non-in-place alters will actually
create a new table which would have a new created value, but most alters
are in-place. Witness:
> select created from systables where tabname = 'tt';
created
07/26/2011
1 row(s) retrieved.
> alter table tt add two integer;
Table altered.
> select created from systables where tabname = 'tt';
created
07/26/2011
1 row(s) retrieved.
>
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, Apr 17, 2012 at 5:50 AM, DOUG LAWRY <douglawry@hotmail.com> wrote:
> SELECT created FROM systables WHERE tabname = ?>
> Regards,
> Doug Lawry
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--90e6ba6e8c0c6ce37804bddd5f31