1 2 3 4 5 6 7 8 9 10 11 12
| MERGE INTO QH_REF QH
USING CONTRAT C
ON (QH.PASTRF=C.PASTRF and QH.PMSTRF=C.PMSTRF and QH.PJSTRF=C.PJSTRF and QH.CODEISIN=C.CODEISIN)
WHEN MATCHED THEN
UPDATE SET
QH.CT_ITU = C.CT_ITU,
QH.LL_TYP_ITU = C.LL_TYP_ITU
WHEN NOT MATCHED THEN
INSERT
(QH.PASTRF,QH.PMSTRF,QH.PJSTRF,QH.CT_ITU,QH.LL_TYP_ITU,QH.TYPINST,QH.LIBTYINS,QH.CD_SOU_TYP_CNT_VAL,QH.LL_SOU_TYP_CNT_VAL,QH.CODEISIN,QH.LIBVAL,QH.DD_CNT,QH.DF_CNT,QH.CD_FAM_RSQ,QH.LL_FAM_RSQ)
VALUES
(C.PASTRF,C.PMSTRF,C.PJSTRF,C.CT_ITU,C.LL_TYP_ITU,C.TYPINST,C.LIBTYINS,C.CD_SOU_TYP_CNT_VAL,C.LL_SOU_TYP_CNT_VAL,C.CODEISIN,C.LIBVAL,C.DD_CNT,C.DF_CNT,C.CD_FAM_RSQ,C.LL_FAM_RSQ); |
Partager