How to compare data between two tables in db2?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,


What is meant by explain?

0 Answers  


What is bind plan?

0 Answers  


When do you specify the isolation level?

0 Answers  


What is reorg?

0 Answers  






How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  


4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


select 100 records from million records ?

2 Answers   Verizon,


What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  


What is a synonym ?

2 Answers  


What is bufferpool in db2?

0 Answers  


Categories