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

How can we read records for specific member in CL? AND rpg?

702

What is ibm db2 client?

941

What is a Foreign Key?

1100

How to connect to db2 database from windows command line?

1066

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

Name the lockable units in DB2?

1128

How do I connect my db2 database to ibm?

1051

How to create db2 table in mainframe?

1155

Is db2 a database?

979

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1077

What is the usage of open cursor command?

1100

What is meant by explain?

1133

What is rct?

1237

What do you mean by storage group (stogroup)?

1041

What is null in db2?

1027