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.


DB2 & UDB email list listserv db2-l LazyDBA home page