Krishna_jilla
Kurra Bewarse Username: Krishna_jilla
Post Number: 1982 Registered: 04-2015 Posted From: 143.115.155.58
Rating: N/A Votes: 0 | Posted on Thursday, October 15, 2015 - 1:27 pm: | |
Stewie:Db2 naa.. dual undademo meeku SYSIBM.SYSDUMMY1 try cheyyi
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' WHERE (D.UUID = '123') WHEN NOT MATCHED THEN INSERT (D.UUID, D.RETRY_CNT, D.ERR_TYP_CD) VALUES ('123', 1, 'RESENT'); ilana bro? |