Batch « db2 « Java Database Q&A

1. DB2 - JDBC2.0 Batch update

2. DB2 Query Batch?

Using DB2 Type4 "Universal" driver against DB2 v8 (on aix) I'd like to do something like this: buf.append("DECLARE GLOBAL TEMPORARY TABLE .....;"); buf.append("update temp table....;'); buf.append("DELETE from temp table where xxx;"); buf.append("select * from temp table;"); bool = stmt.execute(buf.toString()); //process update counts and results sets with //stmt.getUpdateCount(), stmt.getMoreResults(), stmt.getResultSet()... DB2 complains about this some token missing on the first line. I ...

3. db2 batch update using java

4. Batch execute fails in DB2 V9

5. DB2: Using NOT EXISTS with SYSIBM.DUAL in a complex batch query

Hello All, I have data in a java object as data1, data2. data1 and data2 together forms a composite key in myTable where I want to insert the object. The writing is happening as a batch. Like 10 insert statements are prepared using 10 objects and are executed as a batch. I want to insert the above data with the constraint: ...