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

What is null in db2?

567


What is load replace in db2?

557


What is cascading rollback?

613


Highlight all the advantages that are attached to a package.

619


How to find the maximum value in a column in the db2 database?

597






How does cobol compile db2 program?

599


What is plan in cobol db2?

580


What is with ur in db2?

744


What is buffer pool in the db2 database?

608


What is the physical storage length of the data types date, time, and timestamp?

593


what is a corelated subquerry?

648


What is catalog database in db2?

634


What is a db2 cursor?

615


What are foreign keys in db2?

607


What is host variable?

585