What is REORG? When is it used?

4 Answers  

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

What is normalization and what are the five normal forms?

1 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

---

---

What is the maximum length of sqlca?

0 Answers  

---

Is db2 a programming language?

0 Answers  

---

how to resolve -811 error. give clear explination

4 Answers   IBM,

---

What is bufferpool in db2?

0 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---

What is consistency token in db2?

0 Answers  

---