Subject Re: [IBO] Exception Handling with TIB_DataPump
Author Geoff Worboys
Thomas Steinmaurer wrote:
>> I have to transfer a bunch of records in a master/detail
>> relationship. It can happen that the master record identified
>> by an integer primary key value already exists in the
>> destination table. In that case, I simply want to omit/skip
>> this master record and the related detail records and continue
>> with the next master record.
>> Is there a way to do that?

> Any ideas?

Hi Thomas,

I'm not at all certain how you are using datapump to do that
anyway. I'm not up to date with latest versions of IBO, but
I thought datapump was a one-table-at-a-time sort of thing?

I'd probably do it outside the pump with cursors and dsql,
perhaps with the master dsql using a stored proc or execute
block that returns a true/false to indicate whether it
inserted or not, so you know whether to process the detail
for that row.

Probably not all that helpful, I just didn't like leaving you
to the sound of crickets echoing in the empty hall. :-)

Geoff Worboys
Telesis Computing Pty Ltd