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
What do you mean by storage group (stogroup)?
What is alias in db2?
Is schema the same as database?
Why do chiropractors use drop table?
Explain the function of data manager.
What is runstats utility in db2?
what is the responsibility of the construction superintendent
What is db2 look?
What is the use of value function?
What is a db2 tablespace?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Mention some fields that are a part of sqlca.
What is a db2 package?
What is a collection in db2?