XML Bulk Load does not Overwrite Existing Records - XML SOAP

That is not the purpose of the XML Bulkload. You may want to look into
updategrams or write your own logic...

Best regards
Michael

<guxu@hotmail.com> wrote in message
news:1134146895.630165.165350@z14g2000cwz.googlegroups.com...
>I am having problems with XML Bulk Load. I am doing the bulk load
> multiple times, but I was expecting the new data to overwrite the
> existing records if the new record has the same value for the primary
> key as the existing one. However, the XML bulk load does not
> overwrite, it keeps the old records and I get "The statement has been
> terminated" in my log. Is there way to accomplish what I wanted using
> XML bulk load, i.e., always overwrite the old record if the new record
> has the same primary key value as the old one ? The reason I wanted to
> do this was that the data in the columns other than the primary key
> column might have different values every time, so I want to keep the
> most recent data in the table.
>
> Thanks very much.
>