Interested to Buy Any Domain ? << Click Here >> for more details...
in a table consist of 1000 records among that i was updated
145 record how could i know that ..list of recently updated
record's and where could i see those updated
record's....pls help me out....
- 4 Answers
- 11371 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / vaneeshkhurana
In case of any requirement where you have to display the
recently updated records, DB2 generally contains an
additional time stamp coulomb which can be updated with
current time stamp in the updated query.
Now when you want to display the recently updated records,
and an additional AND conditional can be added stating where
time stamp > time when update query ran.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
B37 abend during spufi?
How to access db2 tables in mainframe?
What is dbrm? When it will be created?
What is the cobol picture clause of the db2 data types date, time, timestamp?
what is the sqlcode -501
What is the physical storage length of the data types date, time, and timestamp?
What is cloudant database?
What is the use of value function?
What is dclgen in db2?
Mention data types used in db2 ?
Why do chiropractors use drop table?
What do you mean by cursor?
Explain the function of data manager.
Can we insert update delete in view?
Can one database have multiple instances?
