Skip navigation.
Home
mattfleming.com
Home

Multi-row fetch, insert and update via JDBC in DB2 v8

Submitted by Matt Fleming on Thu, 2005-09-22 01:29.

Okay, I have heard that the new multi-row features present in DB2 v8 are supposed to perform quite nicely.. what I don't know is:

  1. How to implement these things in JDBC/SQLJ?
  2. Is it any better than using batch updates in JDBC/SQLJ?
  3. Are the technologies complementary, mutually exclusive, or different symantics for the same behavior?

Well the answer is that multi-row insert/fetch is DB2 specific terminology. This behavior is activated/implemented in JDBC and SQLJ. In JDBC, the DB2 driver implements multi-row DRDA calls when batch updates are used. In SQLJ, a batch mode ExecutionContext enables multi-row behavior.

»