Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

what is a collection?

2 Answers  

---

when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,

---

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

---

Explain the EXPLAIN statement?

1 Answers  

---

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

---

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.

3 Answers   IBM,

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

What is EXPLAIN?

1 Answers  

---

What is a root page?

1 Answers  

---