JDBC vs DB2 Export - Performance

[Jaime Garcia]

I am working with DB2 and I have to export (2 times per day) a lot of information from a table (DB2 database). I Know that exist a Utility from DB2 (export utility) but, because I need to update the rows that I export, I would prefer to use JDBC (I think that I could have more control with JDBC) but I am worried about performance.
Dose any body Know if the export utility is faster (and better) than using JDBC ?
I Know that importing information is better to use the load Utility, but export information just read rows, so I think (hope) is mostly the same.
Thanks

[Monty Ireland]

the answer is, it depends.
if you are doing a strait extract, export will be much faster.
if you need to extract data population A and update data population B
at the same time. then you have to code and application.
ie.
pgm begin
connect
select ...
update ...
terminate
pgm end
Try to use JDBC 2.0 with addBatch() / executeBatch() if possible.
Hope this helps