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
- 10484 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
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the maximum No of rows per page?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What are the full forms of spufi and dclgen and why are they used?
What is the difference between cursor stability and repeatable read isolation levels?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is database reorganization?
Can we insert update delete in view?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What does sqlcabc has?
what is the responsibility of the construction superintendent
Explain dclgen.
Explain about open switch business continuity software?
What is dbrm? What it contains?
Why db2 is called db2?
