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
- 11191 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
What's The Percentage Free Space ?
Highlight all the advantages that are attached to a package.
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the syntax for seeing the columns and data types of a table in the db2 database?
can we view the access paths created by dbrm ? how ? thx
Explain various types of locks in db2?
What is the role of data manager in the db2 database?
What is reorg and runstats in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is syscat in db2?
List out the three types of page locks that can be held.
Explain db2.
What is nvl in db2?
What is universal database?
What are concurrency issues?
