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....?
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
Discuss about db2 bind?
How can you classify the locks in db2?
How do I start db2 in windows?
How do you find the maximum value in a column in db2?
What is buffer pool and list some of them?
How would you find out the total number of rows in a db2 table?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is the physical storage length of the data types date, time, and timestamp?
How to execute stored procedures?
What kind of database is db2?
How to test SQL -911 error while developing COB-DB2 program
What is universal database?
Is db2 free?
What is the physical storage length of timestamp data type?
Which component is used to execute the sql statements?