If you find a better way (other than big $$ Replication tools) please
let me know... The triggers work but labor intensive - in most cases
I've found EXPORT/LOAD Replace to be easier.

Rick

-----Original Message-----
From: Blair Jensen
[mailto:db2udbdba-ezmlmshield-x2690636.[Email address protected]
Sent: Monday, February 28, 2005 2:00 PM
To: LazyDBA Discussion
Subject: Finding New or Modified Rows

Is there an easy way to find the new or modified rows in DB2? I'm
loading a
data warehouse and want to select only the new or modified rows from
over
500 tables. The only thing I've been able to see so far is a "last
modified" timestamp column that is updated by insert and update
triggers.
Is there an easier way? Please tell me there is.

"Attention: This message is intended only for the individual to whom it
is
addressed and may contain information that is confidential or
privileged. If
you are not the intended recipient, or the employee or person
responsible for
delivering it to the intended recipient, you are hereby notified that
any
dissemination, distribution, copying or use is strictly prohibited. If
you
have received this communication in error, please notify the sender and
destroy or delete this communication immediately."
========================================================================
======


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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