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


Please Help Members By Posting Answers For Below Questions

Mention data types used in db2 ?

677


What is bind and rebind in db2?

648


What is the role of the data page in the db2 database?

587


What is a system catalog table in db2?

586


What do you mean by rollback?

572






How many databases are there?

590


How to rename a table in DB2 ?

637


What is rebind in db2?

574


What is query_cache_limit?

542


What is db2 command?

584


What is concurrency?

709


How does coalesce work?

584


What is package in cobol db2?

702


What is the difference between cursor and select statement?

613


Is db2 a mainframe?

586