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 are the various data types available in db2?
What's The Percentage Free Space ?
What are union and union all?
How to retrieve rows from a db2 table in embedded sql?
What is dclgen (declaration generator)?
How to create db2 table in mainframe?
What is with ur in db2?
What is a cursor in programming?
How do I connect my db2 database to ibm?
What is declare cursor?
If I have a view which is a join of two or more tables, can this view be updateable?
What is syscat in db2?
What is explain plan in db2?
Is db2 free?
Explain the contention situations caused by locks?