Answer / s

EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.

What does it mean if the null indicator has -1, 0, -2?

1 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  

---

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

---

what are bind concepts in db2 cobol?

0 Answers  

---

What is a predicate?

1 Answers  

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

What is commit in db2?

0 Answers  

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

what is db2 restart?

0 Answers  

---

What language is db2 written in?

0 Answers  

---

How to resolve deadlock issue

5 Answers   IBM,

---