使用join语句的DB2更新查询
使用join语句的DB2更新查询
提问于 2019-06-04 07:16:53
我正在尝试更新D_WINTEL_HEALTH表，下面是我正在使用的查询
UPDATE D_WINTEL_HEALTH A
SET A.HEALTH = 7
FROM D_WINTEL_HEALTH A JOIN D_REPORTER_STATUS B ON A.HOST = B.HOST
WHERE B.ALERTKEY = 'kph_netport_xlzc_ilo' AND
B.SEVERITY = 0 AND
A.HEALTH <> 0 我还尝试了另一个查询：
UPDATE D_WINTEL_HEALTH A SET A.HEALTH = 7
FROM (Select D_WINTEL_HEALTH A JOIN D_REPORTER_STATUS B
ON lower(A.HOST) = lower(B.HOST)) s
WHERE s.ALERTKEY = 'kph_netport_xlzc_ilo' AND s.SEVERITY = 0 AND s.HEALTH <> 0 但这两种方法都返回错误如下：
更新-0行，0.000秒DB2 SQL错误: SQLCODE=-104，SQLSTATE=42601，SQLERRMC=FROM;A SET A.HEALTH =7 ;LEFT_BRACKET，DRIVER=4.15.82
测试了工作良好的select查询，不确定问题是什么，它在IBM中是否不同。
回答 2
Stack Overflow用户
回答已采纳
发布于 2019-06-04 08:29:50
使用合并语句代替。
MERGE INTO D_WINTEL_HEALTH A
USING D_REPORTER_STATUS B ON A.HOST = B.HOST
AND B.ALERTKEY = 'kph_netport_xlzc_ilo'
AND B.SEVERITY = 0 AND A.HEALTH <> 0
WHEN MATCHED THEN UPDATE SET HEALTH = 7;Stack Overflow用户
发布于 2019-06-04 07:36:00
尝试使用下面的查询。
merge into AD_WINTEL_HEALTH A
using (select SEVERITY, ALERTKEY from D_REPORTER_STATUS) b
ON A.HOST = B.HOST
when matched and B.ALERTKEY = 'kph_netport_xlzc_ilo' and B.SEVERITY = 0 and A.HEALTH <> 0
then update SET A.HEALTH = 7 页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/56439096
复制相关文章
相似问题
腾讯云开发者
