Subject Re: [IBO] Exception Handling with TIB_DataPump
Author Thomas Steinmaurer
Hi Geoff,

>>> 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. :-)

Much appreciated. ;-)

I will wait if Jason can come up with something, otherwise I have to
discard the IB_DataPump usage and roll my own.

Thanks anyway,