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 the significance of DB2 free space and what parameters control it?

1 Answers  

---

What is deadlock?

2 Answers  

---

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

---

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

---

List out the buffer pools in db2

0 Answers  

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

How to restart a DB2 program?

0 Answers   Cognizant,

---

What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  

---

What is the use of commit in db2?

0 Answers  

---

What is meant by concurrency?

1 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---