---

Krishna_jilla:

MERGE INTO ERR_HOSP D
USING SYSIBM.SYSDUMMY1
ON (D.UUID = '123')
WHEN MATCHED
THEN
UPDATE SET D.RETRY_CNT = 1, ERR_TYP_CD = 'RESENT'

WHEN NOT MATCHED
THEN
INSERT (UUID, RETRY_CNT, ERR_TYP_CD)
VALUES ('123', 1, 'RESENT');

---