What is the difference between bind and rebind in db2?

0 Answers  

---

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

How many buffer pools are available in db2?

2 Answers  

---

What is alias in db2?

0 Answers  

---

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

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

2 Answers  

---

Explain about mirror activator disk mirroring?

0 Answers  

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

---