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
- 10475 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
Why do we use cursor?
How to access db2 tables in mainframe?
How to rename a table in DB2 ?
can we view the access paths created by dbrm ? how ? thx
What are the uses of db2 optimizer?
What is explain in db2?
List down the data types in the db2 database.
What is package in cobol db2?
Explain dclgen.
What is the cobol picture clause of the db2 data types date, time, timestamp?
What does db2 stand for?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
When the like statement is used?
What is the maximum number of columns in a db2 table?
What is a Foreign Key?
