>
> What is this commit_transaction statement?

isc_commit_transaction()

> Is it from IBPP?

from SQLAPI++ (www.sqlapi.com)

> I'd want to find out whether it is a commit with RETAIN.

I don't think so, having looked in the source code of SQLAPI.
However,

> In this case, garbage
> collection never happens until the connection closes, because the same
> transaction stays open and therefore "active" and "interesting". Old
> record versions from active and interesting transactions don't get
> garbage-collected.
>
> This type of updating - where users are hitting the same few rows
> repeatedly - needs a wham-wham-bam approach: explicit hard commit

as soon

> as they post; immediate rollback if they except.

That is exactly what I do

>
> /heLen

Best regards,
Fabrice