How many buffer pools are there in DB2?

2 Answers  

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

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 are some SQL aggregates and other built-in functions?

2 Answers  

---

What is QUIESCE?

2 Answers  

---

---

What is a cursor and what is its function?

2 Answers  

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---

What is a DB2 bind?

3 Answers  

---

What is IMAGECOPY ?

6 Answers  

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers  

---