| 12
 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