Answer / s

Correlated subquery refers to atleast one column of the
outer query. The correlated subquery is evaluated for each
qualifying row from the outer query.

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

List some fields from sqlca?

0 Answers  

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

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?

2 Answers  

---

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

how 2 resolve the -311 sqlcode

1 Answers  

---

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

What is a composite index and how does it differ from a multiple index?

1 Answers  

---

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

What is difference between isnull and coalesce?

0 Answers  

---