I'm trying to update multiple columns with set. However, I'm not sure the correct syntax. Here's what I'm trying to do in SQL.
, updated=current date
from prod.mapping a
join prod.exception b on a.MktgCode=b.mktg_code
Can someone point me to the correct syntax in DB2?
The diagram is very hard to read and understand.
Can someone provide a simple DB2 syntax based on the query I provided? It is basically updating couple of columns when the two tables' join condition is met.
How do the rows returned from your join equate to the table you are updating? Otherwise it would be more of an insert to get one row of data from your updated table with every row from the join condition.