There is no way to find the last record entered unless (possibly) you
get a log reader and physically examine the log. Otherwise you'd have to
do what Suresh suggested. There is nothing inherent to a row in a table
that would give an absolute as to when it is inserted in relation to all
the other rows in the table.
Douglas Kostelnik
Senior Database Administrator/Architect
-----Original Message-----
From: Louw Philip P
[mailto:db2udbdba-ezmlmshield-x96653628.[Email address protected]
Sent: Wednesday, March 28, 2007 8:54 AM
To: LazyDBA Discussion
Subject: RE: recent records in table
A real bad way to get these records does exist if you are reatining your
logfiles.
Restore the backup that was taken befre the insert/update roll forward
to a time before the the records were added. Export the table entries.
Repeat and rollforward till after the records were added Export the
table entries and find the difference.
This is extremely tedious. But if you have to find out when a record was
added this will get you there
-----Original Message-----
From: Khan Nadeem
[mailto:db2udbdba-ezmlmshield-x92589181.[Email address protected]
Sent: Thursday, March 08, 2007 6:39 AM
To: LazyDBA Discussion
Subject: recent records in table
Hi suresh
Is this the only option
Don't we have some other way like some other view where we can find out
-----Original Message-----
From: Suresh
[mailto:db2udbdba-ezmlmshield-x27418555.[Email address protected]
Sent: Wednesday, March 07, 2007 8:43 PM
To: LazyDBA Discussion
Subject: Re: recent records in table
You need to add a new column with data type timestamp to your table
defined with 'NOT NULL WITH DEFAULT CURRENT TIMESTAMP'. When you
insert
new records in to the table, this column will automatically populated
and
you can run queries based on this column to find out the most
recently
added records. :)
Suresh G>
"Khan Nadeem " <db2udbdba-ezmlmshield-x97401630.[Email address
protected]
03/07/2007 03:46 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
recent records in table
________________________________
Gurus,
Can someone tell me how in db2 we can find the latest record in tables
I mean recent inserted ones
Nadeem
This message contains information that may be privileged or confidential
and is the property of the Capgemini Group. It is intended only for the
person to whom it is addressed. If you are not the intended recipient,
you
are not authorized to read, print, retain, copy, disseminate,
distribute,
or use this message or any part thereof. If you receive this message in
error, please notify the sender immediately and delete all copies of
this
message.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or
use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and
notify us immediately at 262-703-7000.
CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's
reserves the right to retrieve and read any message created, sent and
received. Kohl's reserves the right to monitor messages to or from
authorized Kohl's Associates at any time
without any further consent.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message contains information that may be privileged or confidential
and is the property of the Capgemini Group. It is intended only for the
person to whom it is addressed. If you are not the intended recipient,
you are not authorized to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all
copies of this message.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
________________________________________________________________________
__________________________________________________________
Standard Bank Disclaimer and Confidentiality Note
This e-mail, its attachments and any rights attaching hereto are, unless
the context clearly indicates otherwise, the property of Standard Bank
Group Limited
and/or its subsidiaries ("the Group"). It is confidential, private and
intended for the addressee only. Should you not be the addressee and
receive this e-mail by
mistake, kindly notify the sender, and delete this e-mail, immediately
and do not disclose or use same in any manner whatsoever. Views and
opinions
expressed in this e-mail are those of the sender unless clearly stated
as those of the Group. The Group accepts no liability whatsoever for any
loss or
damages whatsoever and howsoever incurred, or suffered, resulting, or
arising, from the use of this email or its attachments. The Group does
not warrant the integrity
of this e-mail nor that it is free of errors, viruses, interception or
interference. Licensed divisions of the Standard Bank Group are
authorised financial services providers
in terms of the Financial Advisory and Intermediary Services Act, No 37
of 2002 (FAIS).
For information about the Standard Bank Group Limited visit our website
http://www.standardbank.co.za
________________________________________________________________________
___________________________________________________________
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
------------------------------------------------------------------------
The information transmitted is intended only for the person(s) or entity to which it is addressed
and may contain confidential and or privileged material and should be treated as a confidential
AAA Auto Club South communication. If the reader of this message is not the intended recipient, you
are hereby notified that your access is unauthorized, and any review, dissemination,distribution, or
copying of this message including any attachments is strictly prohibited.
========================================================================
DB2 & UDB email list listserv db2-l LazyDBA home page