1. DB2 - JDBC2.0 Batch update coderanch.com |
2. DB2 Query Batch? coderanch.comUsing 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 coderanch.com |
4. Batch execute fails in DB2 V9 coderanch.com |
5. DB2: Using NOT EXISTS with SYSIBM.DUAL in a complex batch query coderanch.comHello 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: ... |