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
When reorg is used?
What is page size in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is ALTER ?
What are the various locks available?
Compare a subselect to a join?
Can a Db2 table data be retrived through JCL?
What is the error code -803 ?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
How do I create a view in db2?
How does DB2 determine what lock-size to use?