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
___________________________________________________________________________________________________________________________________
DB2 & UDB email list listserv db2-l LazyDBA home page