Answer / s

For every qualifying row in the outer query the correlated
subquery is evaluated. The correlated subquery has
reference to atleast one column of the outer query.

Non-correlated subquery does not make any reference to the
other query. The subquery is only executed once and the
results are used by the outer query to find the qualifying
rows.

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

What is database manager in db2?

0 Answers  

---

Who uses db2?

0 Answers  

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

What is meant by index cardinality?

2 Answers  

---

What is REORG? When is it used?

4 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

how to resolve -811 error. give clear explination

4 Answers   IBM,

---