What is db2 and what is the use of db2 optimizer?

0 Answers  

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

Discuss about db2 bind?

0 Answers  

---

what is the responsibility of the construction superintendent

0 Answers   Almco,

---

What are the benefits of using the db2 database?

0 Answers  

---

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

When do you use the IMAGECOPY?

4 Answers  

---

How would one remove old reorg information from the DB2 catalog?

2 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---

What does runstats do in db2?

0 Answers  

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---