Answer Posted / m4io

it is not possible in db2 v8 : you still need a cursor.
However : you can fetch 100 rows in one fetch.

01 host-variables.
05 HV-col1-ARRAY PIC s9(04) COMP OCCURS 100 TIMES.
05 HV-col2-ARRAY PIC x(40) OCCURS 100 TIMES.
05 HV-vcol3-ARRAY OCCURS 100 TIMES.
49 HV-vcol3-len-ARRAY PIC s9(04) COMP.
49 HV-vcol3-txt-ARRAY PIC x(40).
05 HV-IND2-ARRAY PIC s9(04) COMP OCCURS 100 TIMES.
I

DECLARE csr1 CURSOR WITH ROWSET POSITIONING for select
col1, col2, vcol3 from ...

open cursor

FETCH NEXT ROWSET FROM csr1 FOR 100 ROWS
INTO :HV-col1-ARRAY,
:HV-col2-ARRAY:HV-IND2-Array,
:HV-vcol3-ARRAY

What is table space in db2?

959

---

Mention the different locking levels that are available in db2.

1070

---

What is the physical storage length of date data type?

1189

---

How can the duplicate values be eliminated from db2 select?

1039

---

What is precompiler in db2?

958

---

What is the physical storage length of time data type?

1064

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2865

---

What is concurrency?

1150

---

What is db2?

1124

---

What is load replace in db2?

936

---

What is buffer pool?

1029

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1102

---

What is multi row fetch in db2?

986

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1227

---

How many databases can be created inside an instance in db2 ?

977

---