Re: question on logical log

stephane.magnan@eur.autodesk.com ("Stephane Magnan") writes: > 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 > Hi Stephane: First, I think you have an Informix OnLine system. In this case, if the transaction doesn't fit in a unique logical log must be a problem. I suggest you that load data using this command: dbload -d dbname -c cfgfile -l output.log -n blknum where: blknum - To do commit after load this number of records. cfgfile - Configuration file must contain: FILE datafile DELIMITER "|" fields_num; INSERT INTO table_name Luck! Antonio Julian.