Answer Posted / shailendra

cursor
declare cursor : it is not exectable statement it take
place in working storage section,it just keep the cursor
on that place where the condition is satisfied which is
define in the quary.


executable statement define in procedure division:

1> open cursor : it define now which cursor open to retrive
data, we can define many cursor at a time.
2> fetch cursor:this statement fetch the record which is
satisfy the condition
3> close cursor : it close the cursor

now if we want to fetch the same record again then it must
to go through open cursor statement again.

What is copy pending status in db2?

1127

---

Explain various types of locks in db2?

1158

---

Explain about mirror activator disk mirroring?

1012

---

What is the connection string to connect to the DB2 Database ?

1128

---

What are types of indexes?

1076

---

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?

2389

---

What is difference between alias and synonym in db2?

1143

---

Is db2 a database?

979

---

Is schema the same as database?

1060

---

what is a corelated subquerry?

1122

---

What is deadlock in db2?

1070

---

What are the benefits of using the db2 database?

1231

---

Explain the function of data manager.

1046

---

Why cursor is used in db2?

1036

---

What is cursor with hold option in db2?

1075

---