hello,
i use db2 v7.2 fixpack 6
the following code should delete some rows (if available) from a table
:
(pst = PreparedStatement, cn = Connection)

String cbox[] = req.getParameter("itemstodelete");
pst = cn.prepareStatement(QueryManager.DELETE_FROM_MYTAB LE);
for (int i = 0; i < cbox.length; ++i) {
pst.setString(1, nesneID);
pst.setString(2, cbox[i]);
pst.addBatch();
}
pst.executeBatch();

pst.executeBatch() throws the followin exception :

[IBM][CLI Driver][DB2] SQL0100W No row was found for FETCH, UPDATE or
DELETE; or the result of a query is an empty table. SQLSTATE=02000

is this a bug or can i do anything against this ? if there are no rows
to delete nothing should be done. how can a achieve this using batch
update ?
any help is appreciated