What will the DB2 optimizer do?

2 Answers  

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

Give the COBOL definition of a VARCHAR field.

2 Answers  

---

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

---

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

1 Answers  

---

---

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

What is the information associated with sysibm.syslinks table?

0 Answers  

---

What happens to the PLAN if index used by it is dropped?

1 Answers  

---

How to execute stored procedures?

0 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---

Explain dclgen.

0 Answers  

---