Multi row updates on the primary key

We are looking at updating a table.

We have data in flat ascii files which will be inserted into the existing table with SQLLOAD.

SQLLOAD does NOT update. Any duplicate records will be written to an dupes file. We can then import these into a temporary table, exactly the same as the first.

The question is, without writing a 3GL type program,how can I:
- update many records in the first table,
with all the duplicate records in the second table?

So far, I have only been able to:
- update one row at a time, if looking at the key in the
where clause.
- update more than one row, but only if I am not looking at
the primary key.

So, in other words, is it possible to update all the records in the first table, while looking at the keys of both tables?

Rodger Received on Fri May 23 1997 - 00:00:00 CDT