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

Why do we bind in db2?

0 Answers  


What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  


How does DB2 store NULL physically?

2 Answers  


What is the picture clause of the null indicator variable?

6 Answers  


How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,






What is dbrm?

0 Answers  


What does a deadlock mean in DB2?

0 Answers  


If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,


What is an inner join, and an outer join ?

1 Answers   CTA,


How to find the number of rows in db2 tables?

0 Answers  


Name the lockable units in DB2?

0 Answers  


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  


Categories