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."
==============================================================================

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