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 / 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
Explain about cursor stability?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Is schema the same as database?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
what is a corelated subquerry?
What is bufferpool in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
How do I delete a table in database?
What is the syntax for creating a table in the db2 database?
What is cursor in dbms?
What is cobol db2?
What is the difference between nvl and coalesce?
When do you specify the isolation level?
How can you do the explain of a dynamic sql statement?
Why db2 is called db2?