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 load and unload in db2
what is a trigger and types of triggers
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
What is a buffer in memory?
How do you eliminate duplicate values in db2?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
How does db2 sample database connect?
What is consistency token in db2?
how can u nderstand the sql stmts executed successfully or not ?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??