in a table consist of 1000 records among that i was updated
145 record how could i know that ..list of recently updated
record's and where could i see those updated
record's....pls help me out....
Answer Posted / vaneeshkhurana
In case of any requirement where you have to display the
recently updated records, DB2 generally contains an
additional time stamp coulomb which can be updated with
current time stamp in the updated query.
Now when you want to display the recently updated records,
and an additional AND conditional can be added stating where
time stamp > time when update query ran.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the maximum number of columns in a db2 table?
If I have a view which is a join of two or more tables, can this view be updateable?
When the like statement is used?
What is universal database?
How can deadlocks be resolved?
What is coalesce in db2?
Define sqlca.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How to find the maximum value in a column in the db2 database?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is db2 look?
What does db2 plan contain?
What is db2 and what is the use of db2 optimizer?
What is difference between isnull and coalesce?
How do you stop a db2 database in linux?