Subject | RE: [IBO] TIB_DataPump |
---|---|
Author | Alan McDonald |
Post date | 2004-02-28T10:56:39Z |
> Alan, I don't have a SP.In IB_DataPump, the DstStatement can be any IB_Query or IB_Cursor etc. If
>
> I have two databases and I'm trying to copy( INSERT OR UPDATE )
> some data betweeen them.
> To do this I am using TIB_DataPump.
> But it can only INSERT or UPDATE.
> I need both, from here starts problems.
> I cannot manage existing data with SAME PK.
> I need something like TIB_Query UpdateSQL in DataPump.
>
> Seems impossible that TIB_DataPump cannot manage code to INSERT
> And Or UPDATE data.
>
> THANKS for Your time, Alan.
>
> Ciao
> Arnaldo
>
you put your code previously listed as a stored procedure on the destination
db and use a component to access it, the you can call the SP via "EXECUTE
MYSP(paramlist...)"
No?
Alan