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
- 9778 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 do you mean by between and in? Is between inclusive of specified range values?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How to check table size in db2 sap?
List out the three types of page locks that can be held.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
i want to maintain uniqueness on pdf without make lf??????????
What is the use of with ur in db2?
What's The Percentage Free Space ?
Explain the function of data manager.
What are the contents of dclgen?
What is data manager?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How to execute stored procedures?
What is commit in db2?
What are the 2 sqlcodes that are returned?
