Answer / s

EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.

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

2 Answers   CGI, Value Labs,

---

What is reorg in DB2

3 Answers   Virtusa,

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

---

What does the CHECK Utility do ?

1 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

---

What is the difference between bind and rebind in db2?

0 Answers  

---

What is cursor stability?

1 Answers  

---

What is a view? Why use it?

2 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---