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
How do I change the column size in db2?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
What is difference between *omit and *nopass?
What is the purpose of using commit?
What type of database is db2?
Can SQL statements/queries be included in a copybook?
How to connect to db2 database from windows command line?
What are some SQL aggregates and other built-in functions?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
In which column of which DB2 catalog would you find the length of the rows for all tables?