if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

What is table space in db2?

0 Answers  

---

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,

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---

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

0 Answers  

---

What will the FREE command do to a plan?

2 Answers  

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

What does the REORG Utility do?

2 Answers  

---

What is meant by concurrency?

1 Answers  

---

What is the maximum length of sqlca?

0 Answers  

---