Answer / sunil1405

join is more efficeint, Subselect can be written as a join.

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

---

How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,

---

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---

Why do we bind in db2?

0 Answers  

---

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

How do you filter out the rows retrieved from a Db2 table ?

1 Answers  

---

Where is the output of EXPLAIN stored?

2 Answers  

---

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

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,

---

When is the access path determined for dynamic SQL?

2 Answers  

---