What is difference between isnull and coalesce?

0 Answers  

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

---

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

0 Answers  

---

How do I create a view in db2?

0 Answers  

---

Which component is responsible for processing sql statements and selecting access paths?

0 Answers  

---

What is REORG? When is it used?

4 Answers  

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

---

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,

---