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,

---

how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,

---

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,

---

What is runstats and reorg in db2?

0 Answers  

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

---

If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  

---

When is the access path determined for dynamic SQL?

2 Answers  

---

what is the use of bind parameter, Replace?

5 Answers   IBM,

---

What is a buffer in memory?

0 Answers  

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  

---

Explain dclgen.

0 Answers  

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---