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

How to create backup table in db2?

1079

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3569

---

What is runstats and reorg in db2?

1293

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2320

---

How do I change the column size in db2?

1141

---

What is phantom read in db2?

1145

---

Can you tell me how can you find out the # of rows updated after an update statement?

1091

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2355

---

Is the primary key a clustered index?

1135

---

How is a typical db2 batch pgm executed?

1167

---

What are iseries servers?

1068

---

What is db2 and what is the use of db2 optimizer?

1047

---

How do you pull up a query which was previously saved in qmf?

1145

---

What is the maximum length of sqlca?

1512

---

How can we retrieve the total number of records in RPG & CLLE?

641

---