You should use the SavePoint method to effect a commit.

HTH,
Jason Wharton

----- Original Message -----
From: "Thomas Steinmaurer" <ts@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, May 20, 2010 1:13 PM
Subject: [IBO] Commit interval with TIB_DataPump?


> Hello,
>
> any ideas on how to implement a commit interval (= doing a commit after
> processing a particular number of source records) with TIB_DataPump?
>
> I've tried to call Commit/CommitRetaining in various events of
> TIB_DataPump (e.g. AfterExecuteItems, AfterFetchRow, BeforeExecuteItems)
> but in all cases I end up with an exception, which might differ.
>
> Any ideas on how to implement a commit interval?
>
>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
> My blog:
> http://blog.upscene.com/thomas/