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
what is REORG? what is the use?
Which component is responsible for processing sql statements and selecting access paths?
pls explain the precompilation process of cobol-db2 pgm
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?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
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
What is a DBRM, PLAN ?
What techniques will be used to avoid deadlock??
What is db2 instance?
Explain the contents that are a part of dclgen.
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?
What is commit in db2?