--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> At 04:27 PM 16/03/2004 +0000, you wrote:
>
> > > >There is very little information on this error, but what there

is

> > > >seems to point to excessive commit retainings without a commit.
> > >
> > > You are right on the button. In IB, you need to ensure you do a
> >hard
> > > commit (not commit retaining) about once every 10,000 updates.
> > >
> > > Helen
> >
> >Yes, but if I'm using the script function in IB_SQL and putting
> >COMMIT statements in the script, isn't this what I'm doing or am I
> >missing something?
>
> You didn't mention a script, you mentioned commitretaining...but if

you

> have a statement in your script that operates on 75,000 rows,

commits,

> operates on 100,000 rows, commits...that's too many operations per

transaction.

>
> Helen
>

I thought that the COMMIT statement would close the transaction and
the next update statement would start a new transaction. Is this not
the case? If so, what would be the best way to run a script like this?