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 table?
What is the maximum length of sqlca?
What is multi row fetch in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
List some fields from sqlca?
Who uses db2?
Discuss about db2 bind?
Can you use max on a char column?
How to get the ddl of a table in db2?
What is check constraint in db2?
Where do you specify them?
How to connect to db2 database from windows command line?
How can you do the explain of a dynamic sql statement?
What is role in db2?
Is the primary key a clustered index?