Answer Posted / raja mohan reddy

As of my knowledge,we cannot fetch multiple rows with out
using cursor in cobol db2, Let us see the breif explanation

When you are trying to fetch multiple rows with select
statement using perform loop it gives the result as
fetches the first row while fetching the second row program
will be end with sqlcode.

Here is the only one way to fetch multiple rows from db2
table using cobol. Please follw the following steps.

1.Declare a cursor ( we have to code SELECT statement with
our criteria)
2.Open the cursor
3.fetch the rows using cursor
4.Close the cursor

Please Let me know if you find any mis stated information

Which component is responsible for db2 startup and shutdown?

979

---

what is the role of the cursor in db2?

999

---

List out the buffer pools in db2

1018

---

What is the maximum size of varchar data type in db2?

1063

---

What does db2 stand for?

958

---

What db2 400?

1101

---

How can you classify the locks in db2?

1031

---

What is copy pending status in db2?

1067

---

List out the data types available.

1080

---

What is the meaning concurrency in the db2 database?

1054

---

What is package in db2 mainframe?

916

---

How can you count the number of rows from a table tab?

1038

---

what is the responsibility of the construction superintendent

2078

---

Define buffer pool.

996

---

What are the various isolation levels possible?

1047

---