DB2合并不插入不匹配时

Question

我的语句：

MERGE INTO tblshoppingcart AS target USING 
(SELECT * FROM tblshoppingcart 
WHERE session_id = 'f7f2eb03-5ca5-4a85-b83e-70f197c087ae ' AND primlink = '19830625000054' AND store = 17 AND catalog = 'SS3' AND quantity = 35 AND item_type = 0) AS source 
ON target.primlink = source.primlink AND 
target.session_id = source.session_id AND target.item_type = source.item_type 
        WHEN NOT MATCHED THEN 
        INSERT VALUES ( 'f7f2eb03-5ca5-4a85-b83e-70f197c087ae', '19830625000054', 17, 'SS3', 'PAS', 35, 5, '', 0 ) 
WHEN MATCHED THEN 
UPDATE SET quantity = 15

匹配时更新的工作正常

当不匹配时，插入物不会丢失错误，但也不会插入任何内容。

Answer 1

在不匹配时尝试更改，然后与：

WHEN NOT MATCHED BY TARGET THEN

Answer 2

谢谢，我发现问题是我正在通过硬编码值，但是当我使用源/目标名称时，它可以使用。

所以而不是 INSERT VALUES ( 'f7f2eb03-5ca5-4a85-b83e-70f197c087ae'

我做INSERT VALUES ( target.session