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.

List down the data types in the db2 database.

1038

---

Define sqlca.

1052

---

How do you select a row using indexes in db2?

1072

---

What is the max length of sqlca?

1156

---

What is data manager?

993

---

What parameters are used to control the free space in DB2?

1006

---

Is db2 a mainframe?

968

---

Explain the contention situations caused by locks?

1012

---

What is a db2 package?

986

---

is it compulsory commitment control in journal?

2413

---

What do you mean by cursor?

942

---

Mention the location where the output received from explain statement is stored.

1053

---

What is concurrency?

1147

---

What is the physical storage length of timestamp data type?

1023

---

What are host variables in db2?

989

---