I am using cursor as below
“Declare cursor C1
rowset positioning
with hold for
Select columns-list from table-name
for update .. ”

“ DELETE FROM table-name
WHERE CURRENT OF C1 FOR ROW :IDX OF ROWSET“
I am getting error on positioned delete of multiple fetch. The SQLCODE=-904 ie unavailable resource (showing table space name). I am fetching 100 rows at a time and I am getting error after processing few rows. What could be the reason to this?.

I suspect tablespace became unavailable for reason other than your cursor processing. Either that or there has to be more in the SQLCA that describes the error.