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

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 ?

2387

---

What is the difference between cursor and select statement?

1152

---

Is db2 free?

1141

---

When reorg is used?

1182

---

How do I delete a table in db2?

1124

---

Which are the db2 tools to protect integrity of the database?

1166

---

How to access db2 tables in mainframe?

1102

---

How can the duplicate values be eliminated from db2 select?

1159

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1536

---

How to execute stored procedures?

1175

---

How can we read records for specific member in CL? AND rpg?

757

---

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

1173

---

How connect db2 database to datastage?

1289

---

What does sqlcabc has?

1098

---

What is the function of logging in the db2 database?

1172

---