Given table a: col1 col2 name1 name2 where col1 and col2 make up the
unique key.
Given a stage table b: col1 col2 name1 name2. (again unique key same
as a)
table a has 34M rows
table b has 2 million rows
i want to update table a's name1 and name2 with the values from table
b
where a.col1 = b.col1 and a.col2 = b.col2.
I don't think this can be done within a sql update statement so I am
writing a program to do a cursor update; However I would think the
db2 engine would be more efficient.
Can it be done?
Thanks,
Mike