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.

B37 abend during spufi?

1463

---

What type of database is db2?

974

---

Mention data types used in db2 ?

1166

---

What is sqlca’s maximum length?

1197

---

What is iseries database?

1056

---

what is db2 restart?

2165

---

Explain db2.

1041

---

How to check sequence on a table in db2?

1068

---

Explain about mirror activator disk mirroring?

1018

---

What is scrollable cursor in db2?

1059

---

What is the syntax for FETCH in DB2 ?

1222

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

---

What is db2 stogroup?

1168

---

How will you return the number of records in table?

944

---

Define declaration generator (dclgen).

1123

---