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
Discuss about db2 bind?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the connection string to connect to the DB2 Database ?
How can the duplicate values be eliminated from db2 select?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Describe major components of db2?
Can you use max on a char column?
Is db2 a mainframe?
What are concurrency issues?
How do I import data from excel to db2?
What is a db2 tablespace?
Define predicate?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What's The Error Code For Unique Index Voilation?
How to check last update on table in db2?