Hi

Sorry, just worked out ho to do it.

For anyone who is interested. In the Dest IB_Cursor change
'CheckRequired' to false.


Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Robert martin wrote:

>Hi
>
>We use an IB_Datapump to copy data from one table to another. Usually
>these are the same structure but if not the datapump seems to handle it
>fine. However we have one table where we have the following situation.
>
>Source Table
>
> SerlNumRef BigInt NOT NULL,
> TransRef BigInt NOT NULL,
>.....
>
>CPK is SerlNumRef, TransRef
>
>Dest Table is
>
> SerialMovRef Bigint NOT NULL,
> SerlNumRef BigInt,
> TransRef BigInt,
>.....
>
>SerialMovRef is the New PK and has a trigger that fills it in if null.
>
>However the DataPump fails on this. Is there a setting I am missing or
>is this type of datapump not possible?
>
>
>