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
- 10780 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
How can you count the number of rows from a table tab?
What is the use of reorg in db2?
Are views updateable?
What is drop table?
What is isolation level in db2?
What is runstats db2?
What is cursor in dbms?
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?
can we view the access paths created by dbrm ? how ? thx
What is alias in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is copy pending and check pending in db2?
How to execute stored procedures?
What is lock escalation in db2?
What do you mean by between and in? Is between inclusive of specified range values?
