How can you compare table column after update and before
update?
Answer Posted / kingmanish
Its always industry practice to take Image copy of the
table before going for inserts updates etc.
you can unload current data from the table and the data
from the image copy before update and compare the two.
thanks
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is a db2 tablespace?
What is commit in db2?
Mention the location where the output received from explain statement is stored.
What are the full forms of spufi and dclgen and why are they used?
How to resolve deadlock issue
Why do we use cursor?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is explain plan in db2?
What is sqlca?
What is a bind card?
How can we retrieve the total number of records in RPG & CLLE?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is a db2 cursor?
What is a page in db2?