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
- 11536 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
How to get the ddl of a table in db2?
What is ibm db2 used for?
What is page size in db2?
How do you eliminate duplicate values in db2?
Is db2 a mainframe?
What is db2 bind?
What does db2 stand for?
What is ibm db2 client?
Mention the various locks that are available in db2.
What r the comman abends in db2, jcl and cobol???????
what is a corelated subquerry?
What is a Foreign Key?
How to find the number of rows in db2 tables?
What type of database is db2?
If I have a view which is a join of two or more tables, can this view be updateable?
