Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

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,

---

How many sub queries can you combine together ?

4 Answers   IBM,

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

What is db2 isolation?

2 Answers  

---

---

what is plan? is plan executable or package?

4 Answers  

---

What is meant by explain?

0 Answers  

---

What is an alias?

3 Answers  

---

What is meant by repeatable read?

4 Answers  

---

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

What is the use of dclgen in db2?

0 Answers  

---