Replacing multiple statements with a MERGE

#11

I want to add a note.

Quote:

WHEN NOT MATCHED
AND EXISTS
(SELECT 0
FROM Auctions e
WHERE e.item_id = b.item_id
) THEN
INSERT

I also tried:

WHERE m.item_id = a.item_id

It returned error:
SQL0206N "A.ITEM_ID" is not valid in the context where it is used.

So, I thought that the target table can't be referred in WHEN NOT
MATCHED clause.
And it would be rational.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Replacing multiple statements with a MERGE

comp.databases.ibm-db2 comp.databases.ibm-db2

Re: Replacing multiple statements with a MERGE - 06-30-2010 , 05:31 PM