Large Delete Problem

Hi Everyone, I have a situation where my application is trying to do a large delete (actually it's a delete with no where clause) and its hitting a "long transaction abort". System: risk6000 4.1 ------- Informix Online 7.2 Application using ODBC CLI What we already know: --------------------- 1. Database configauration can be changed to avoid a long transaction abort. 2. Since statement in question is deleting everything in the table we can drop and create the table. The problem: ----------- 1. We donot have any control over the database configuration. I cannot make any assumtions of a certain log file size or space either. 2. We would prefer a controlled delete rather than a drop or create the table. The question: ------------ Does anyone know of a way doing a delete, say, 2000 rows at a time? Mind the fact the table is not ordered in any way. Thank you. Bappy