Hi,

I have a requirement where I have to delete 1000 records from a single table for a given set of conditions. How can I go ahead with JDBC batch? Is there any perormance issue for this approach? If few of the records are not deleted from this batch, then the whether all others will be commited?

Thanks for the help.

Regards,
nd1980

delete from .. where ..
if statement executed and not succeeded it will be rolled back
the only problem could be logspace (not with 1000 rows)

Actually My requirement is to do the batch delete from a JAVA application through JDBC Batch feature. My concern is if few records are not getting deleted, then whether the whole batch will be rolled back?

it depends on the commit
it will rollback to last luw
(I find it strange that so many people are trying to use DB2 and have not read at least 1 book about it or never consult the online infocenter)

Why should they when there are so many people willing to spoon feed them (instead of asking them to RTFM) on this forum in order to rack up posting counts (must be in their performance plan)?

I have answered a lot of questions, but I make a lot of references to the manuals, usually telling them exactly which manual to look in.

I may be wrong... but I have a feeling that I'm part of this group of people. Given them hints and telling to RTFM is perfectly fine (and this is what I try to do), but this doesn't work for all. I get to work with different kinds of people - some are extremely knowledgeable DBAs and one hint is more than enough and some are very new to DB2 or the DBA role. So, giving them a few hints and telling to RTFM is often not enough. So, I'm kind of used to "spoon feed them". If this is against the rules of this forum, then I'll stop.

And I'm not doing it to "rack up posting counts"... I could care less about it.

it isn't

the only time you should not offer a solution is when it's an obvious homework assignment