Interested to Buy Any Domain ? << Click Here >> for more details...
in my table i will update only 100 record among 1000
records i need to display recently updated record'.....can u
tell me where those records are stored how can i display
those records...?if there is any sql query pls let me know....?
- 3 Answers
- 10602 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / kingmanish
Generally while updating rows in table we also update te
sourcr by which the rows were update( like program id)
also upadate date etc.
we can retrive the records having timestamp of the time the
rows were updated or the program name which was used to
update the table
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we delete records from view?
What is dpf in db2?
Explain how can you do the explain of a dynamic sql statement?
What do you mean by between and in? Is between inclusive of specified range values?
Before you give the explain statement, what are the prerogatives?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Define buffer pool.
Differentiate between cs and rr isolation levels? Where do you specify them?
Explain in brief how does db2 determine what lock-size to use?
What is the role of union all and union
How do I add a column to an existing table in db2?
What is cobol db2?
What is cloudant database?
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 do I create a view in db2?
