Subject | Commit interval with TIB_DataPump? |
---|---|
Author | Thomas Steinmaurer |
Post date | 2010-05-20T19:13:57Z |
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/
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/