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
- 10625 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
What is the advantage in De-normalizing tables in DB2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the maximum size of a char data type in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is data manager?
What is lock escalation in db2?
Define db2 and its databases?
What do you mean by cursor?
what is a corelated subquerry?
How is deadlock resolved?
Is db2 relational database?
What is null in db2?
What are packages in db2?
How do I add a column in db2?
