question on logical log

No it will not COMMIT after so many inserts for you. You could use it for your smaller tables. The best is to use "DBLOAD". You will have to monitor you logical logs and should back them up if you see that they are getting full. DBLOAD allows you to commit periodically and will also continue loading if bad data records are trying to be inserted in to a table. You have control over rather or not to allow this processing and what to do once a certain amount of bad data records have been attempted to be inserted. You also can have it keep those bad data records in a file for later reviewing...... Check out DBLOAD it's your best option!!! C.L. Kendricks vnibs2@heb.com --------------------------( Forwarded letter 1 follows )--------------------- Date: Thursday, 13 March 1997 8:51am Date:Thu, 13 Mar 1997 05:27:51 -0600 From: stephane.magnan@eur.autodesk.com To: informix-list@rmy.emory.edu Subject: question on logical log Sender: informix-list-owner@rmy.emory.edu Reply-To: "Stephane Magnan" <stephane.magnan@eur.autodesk.com> X-Informix-List-Id: <list.13531> Hi, This week-end, we have to load data in a database. I would like to know if we will meet a problem with long transaction. We want use the sql statment 'load from filename ....' Could you tell me if this command execute sometimes 'commit' or it commit at the end of loading. Stephane