Dear all,

I know that we could insert data from a table to another table by

insert into A(F1,F2) select F1,F2 from B;

However, it seems that DB2 doesn't have insert update for this kind of
statement (i.e. The insertion failed if primary key already exist in A,
while we could do this in import statement)

Is that I missed something from the manuel? The work around I think of
is to delete the records beforehand, could anyone tell me whether this
could be done in the same statement?

Thanks in advance!

Henry