Re: question on logical log

Hi Stephane, As far as I know, 'load from...' runs as one transaction, and if it finds ONE error in the input file, it stops. Look up 'dbload' in the manual - this commits every 100 rows, and reports any bad rows without interrupting the process. The number of bad rows it skips over before aborting is configurable, as well as (I think) the number of rows loaded between commits. HTH, Richard. At 12:27 13/03/97 MET, you wrote: > 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 > >