replicat is issuing "transaction rolled back" warning messages in report file
Source is an 'IBM for i on POWER' legacy DDS defined file with multiple members, but only one primary key.
My Extract mapping looks like: TABLE INPRDDTA2/INJLIRP(*ALL);
My Pump mapping looks like: TABLE INPRDDTA2/INJLIRP(*ALL), TARGET INPRDDTA2/INJLIRP(*ALL);
My Replicat mapping looks like:
MAP INPRDDTA2/INJLIRP(*ALL), TARGET INA400_LANDING.INJLIRP,
KEYCOLS (JLCMPY, JLAWH5, JLDEPT, JLVEND, JLSUFF, JLITEM) ,
COLMAP (USEDEFAULTS,
JLYTD_DOLLAR = JLYTD$ ,
JLADDD_JLADDT_ISO = ~TO_ISO_TIME (JLADDT, ~TO_ISO_DATE(JLADDD)),
SOURCE_MEMBER_NAME = @STRSUB(@STRSUB(@STREXT(@GETENV ('GGHEADER', 'TABLENAME'), 19,28),')',''),'(',''));
On the target we added the 'SOURCE_MEMBER_NAME' column to help make the data unique.