Answer / chinmay

cursor is a programming devive which can keep to allow a set of rows and return them one row at a time because the host language can deal one row at time

Answer / madhavansvce

Cursor is a multiple column can be moved possible.

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  

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

what is plan? is plan executable or package?

4 Answers  

---

Explain various types of locks in db2?

0 Answers  

---

What is a DB2 catalog?

2 Answers  

---

---

What are the various locks available?

5 Answers   CTS,

---

List out the buffer pools in db2

0 Answers  

---

What is meant by index cardinality?

2 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

What is the physical storage length of timestamp data type?

0 Answers  

---

what is datacom db?

2 Answers   CSC,

---