Answer / sravani

when sql statements are not changed but a new index is added or runstats is run,then it is advisable to do a rebind for the
best possible access path. rebind plan is cheaper than bind with action(replace)

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

What is a collection in db2?

0 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

what is the difference between join and union?

4 Answers   IBM,

---

What is temporal table in db2?

0 Answers  

---

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---

What is explain plan in db2?

0 Answers  

---

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

4 Answers   Accenture,

---

What is the maximum size of a char data type in db2?

0 Answers  

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,

---

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,

---