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


Please Help Members By Posting Answers For Below Questions

What kind of database is db2?

572


What are the rules for db2 programming?

643


What is dpf in db2?

666


What is syscat in db2?

580


What is ibm db2 used for?

601






Explain package in db2 and its advantages?

598


Is db2 a database?

574


Explain db2.

620


What is null indicator in cobol db2?

586


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

614


How can deadlocks be resolved?

542


What is the physical storage length of date data type?

732


What are the various isolation levels possible?

649


What is runstats db2?

585


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2379