Answer Posted / krishna reddy

we must know max no of records we want to fetch.
suppose max no record 50...

01 host-variable.
02 employee occurs 50 times.
05 eno pic 9(4).
05 ename pic A(20).
05 esal pic 9(5).

Declare cursor c1 for select eno,ename,esal from emp;

open c1.

fetch c1 into :host-variable.

What is data manager?

1101

---

What is a db2 collection?

1107

---

Discuss about db2 bind?

1154

---

What is db2 connect?

1124

---

What is schema in db2?

1081

---

i want to maintain uniqueness on pdf without make lf??????????

2204

---

What is the difference between oracle and db2?

1170

---

Where do you specify them?

1366

---

List out the buffer pools in db2

1128

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2436

---

What is deadlock in db2?

1118

---

What is bind and rebind in db2?

1186

---

What is dbrm? What it contains?

1214

---

How can deadlocks be resolved?

991

---

How to check table size in db2 sap?

1095

---