>>>>> On Fri, 08 Nov 2002 00:26:33 +1100, Helen Borrie <helebor@...> said:

HB> This is a very inefficient way to do a batch transfer,
HB> especially such a huge one. I hope your users are patient.

Uhm, given to tone of your statement, there must obviously be an
"efficient" way of doing it! How are you seeing it? A single SP that
does something like

BEGIN
INSERT INTO table (pk, data) VALUES (:pk, :data)
WHEN SQLCODE -803 DO UPDATE table SET data = :data WHERE pk = :pk
END

? Or from external tables?

mine-users-are-less-patient-then-yours-ly :),
thanx&bye, lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.