Based on the situation, one can use Union/Inner Join.

How can you compare table column after update and before
update?

Question Posted / harsha

Answer Posted / harsha

Is This Answer Correct ?

0 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Are view updateable?

972

How do we specify index to include or not during bind process.

2069

Explain various types of locks in db2?

1079

is it compulsory commitment control in journal?

2411

What is the difference between plan and package in db2?

1033

What is a db2 table?

953

How is the value function used?

1078

List down the types of triggers in the db2 database?

959

How can you do the explain of a dynamic sql statement?

1008

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1001

How can you classify the locks in db2?

1028

What is the purpose of using commit?

1037

Name the various locking levels available?

1033

How to find the number of rows in a db2 table?

1062

What is runstats db2?

961