--- In ib-support@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 08:00 AM 10-12-02 +0000, you wrote:
> >Hi and thanks every one. I think this kind of support is the best.
> >The growing database was (of cause) due to my lack of skill in DB-
> >programming. I did COMMIT RETAINING instead of COMMIT. But from
what
> >I understand this only stores some kind of Save Point and it does
> >not a real COMMIT.
>
> It's not a Savepoint (although Savepoints *are* coming in Fb 2).
It is a
> full (irreversible) Commit but, instead of closing the cursors
associated
> with the transaction, it keeps them open for the new transaction.
Hence,
> everything to do with the original transaction and each new one
that is
> started after Commit with Retain, using the same cursors, remains
> interesting and therefore unavailable for garbage collection.
>
> heLen