BEGIN ATOMIC
IF EXISTS(SELECT rela.ACLN_ID FROM pgma.M_LINE_DOT_RELA rela WHERE rela.ACLN_ID=104254) THEN
DELETE FROM M_LINE_DOT_RELA r WHERE r.ACLN_ID=104254;
ELSE
INSERT INTO PGMA.M_LINE_DOT_RELA (CE_DOT_ID, ACLN_ID, ACLN_DOT_ID, ACLN_DOT_INDEX, ACLN_DOT_ATTR)
VALUES (104255, 104254, 104231, 0, '1');
END IF;
END
注意语句结束之后要有分号
DB2 IF EXISTS写法
最新推荐文章于 2022-08-20 14:35:13 发布