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
- 11552 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 is the difference between cursor stability and repeatable read isolation levels?
Is db2 a mainframe database?
What is the use of with ur in db2?
What is db2 stogroup?
How to test SQL -911 error while developing COB-DB2 program
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
List out the buffer pools in db2
What is db2 plan table?
What is sqlca’s maximum length?
Mention the definition of cobol in varchar field.
What is runstats utility in db2?
How to create backup table in db2?
Mention the various locks that are available in db2.
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is drop table?
