ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE


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

Post New Answer

More DB2 Interview Questions

what is REORG? what is the use?

4 Answers  


Which component is responsible for processing sql statements and selecting access paths?

0 Answers  


pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  


What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  






Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  


What is a DBRM, PLAN ?

3 Answers  


What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,


What is db2 instance?

0 Answers  


Explain the contents that are a part of dclgen.

0 Answers  


While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,


What is commit in db2?

0 Answers  


Categories