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
- 10421 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / adarsha
Use the DB2 COPY Utility with Incremental Image copy.. which
give you the latest update done to a prticular table/table
space from last update .. below is the utility step
COPY TABLESPACE DSN8D51A.DSN8S51E
FULL NO
SHRLEVEL CHANGE
Use jcl for that
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What's The Error Code For Unique Index Voilation?
What types of tables are there in the db2 database?
What do you mean by commit and rollback?
Why do we use cursor?
When reorg is used?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What do you mean by rollback?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is an instance database?
Is ibm db2 free?
Describe major components of db2?
Is db2 free?
What do you mean by storage group (stogroup)?
What does runstats do in db2?
