Is it possible to combine UPDATEDELETES and RESOLVECONFLICT in the same MAP
Hi,
- I need to use UPDATEDELETES and RESOLVECONFLICT in the same MAP statement :
UPDATEDELETES
MAP PIVOTMAT2.PS_SF_OP_TIME, TARGET STGPIV.PS_SF_OP_TIME_TEST, &
RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, OVERWRITE)), &
COLMAP(USEDEFAULTS, &
DML_DATE=@GETENV("GGHEADER", "COMMITTIMESTAMP"), &
DML_TYPE=@STRSUB(@GETENV("GGHEADER","OPTYPE"),"DELETE","DL","SQL COMPUPDATE","UP","PK UPDATE","UP","INSERT","RR"), &
DML_SCN=@GETENV("TRANSACTION", "CSN"));
With this MAP, UPDATEDELETES doesn't work.
- The only way i found to do this mapping is to use ALLOWDUPTARGETMAP and split in two statements :
ALLOWDUPTARGETMAP
IGNOREINSERTS
GETUPDATES
GETDELETES
UPDATEDELETES
MAP PIVOTMAT2.PS_SF_OP_TIME, TARGET STGPIV.PS_SF_OP_TIME_TEST, &