what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

What are bind parameters in db2?

0 Answers  

---

---

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

Mention the different locking levels that are available in db2.

0 Answers  

---

Name the different types of Table spaces.

5 Answers   IBM,

---

What are the full forms of spufi and dclgen and why are they used?

0 Answers  

---

what are the bind parameters?

5 Answers   IBM,

---