DB2 MERGE 사용하기

오라클과 비슷한 문장 구조

 

Case1.

MERGE
    INTO S2B.A AS NEW
   USING (SELECT KEY
                 FROM S2B.B
                WHERE KEY = #key#) AS OLD
       on NEW.KEY = OLD.KEY
   WHEN MATCHED THEN
              UPDATE
              SET 
   WHEN NOT MATCHED THEN
              INSERT
                   ( 
                   )
              VALUES
                   ( 
                   )      

 

Case2.

MERGE
INTO S2B.A AS NEW
USING (SELECT COUNT(KEY) CNT
              FROM S2B.A
             WHERE KEY = #key#) AS OLD
on 1 <= OLD.CNT

AND NEW.KEY = #key#
   WHEN MATCHED THEN
UPDATE
SET
WHEN NOT MATCHED THEN
INSERT
(
)
VALUES
(
)