Answer / sunil1405

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

what is a collection?

2 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

How to connect to db2 database from windows command line?

0 Answers  

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

What is QUIESCE?

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,

---

What is buffer pool?

0 Answers  

---

What is a thread?

3 Answers  

---

Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers  

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

What is an asychronous write?

1 Answers  

---