Answer / s

Cursor is used by DB2 to fetch qualified rows one row at a
time to the application program.

Answer / harsha

cursor is used to retrive multiple rows.

What is view db2?

0 Answers  

---

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?

1 Answers   HeadStrong,

---

What is the use of commit in db2?

0 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What is the difference between spufi and qmf?

0 Answers  

---

What do you do to keep the cursor from closing after a commit?

1 Answers  

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

What do you mean by commit and rollback?

0 Answers  

---

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

How to find schema of a table in db2?

0 Answers  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---