Interested to Buy Any Domain ? << Click Here >> for more details...
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....
- 4 Answers
- 11384 Views
- Infosys, I also Faced
- E-Mail Answers
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
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How to check sequence on a table in db2?
Which component is responsible for db2 startup and shutdown?
How do I connect my db2 database to ibm?
What is the use of db2?
What are the 2 sqlcodes that are returned?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is an instance database?
What is a db2 table?
What is database reorganization?
Define check constraint.
What do you mean by between and in? Is between inclusive of specified range values?
Define declaration generator (dclgen).
What is the difference between nvl and coalesce?
Explain various types of locks in db2?
