Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images

Rate this post by selecting a number. 1 is the worst and 5 is the best.

    (Worst)    1    2    3    4    5     (Best)

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

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?

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration