The only way I know to do a control delete is using a stored proc with a commit count every x records. on the other hand if you want to truncate a table basically, I have posted a db2 cheat sheet that explains how to basically truncate in db2.
Also, note if you are doing large deletes you wil need to reorg the table often.
Hello Sumeet, thanks for the advice. I need to do this delete on a production table that should have been truncated nightly in a batch job but the job was never implemented. I ended up doing the job in chunks manually.
briankalberer, thank you for your reply also. Would you happen to know if DB2 offers a built-in scripting language similar to Oracle's PL/SQL instead of having to resort to Java/C?
Db2 has there version of PL SQL. When you use the stored proc builder you can use sither java or sqlproc, for coding languages. If you need some code examples I have replied to a few other db forums post its with attachments of code.