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 the difference between join and union?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
How do you filter out the rows retrieved from a Db2 table ?
What is reorg in database?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
what is sql abend code -801,-802?
What is the syntax for FETCH in DB2 ?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What techniques will be used to avoid deadlock??