-- put values from source file into target file
MERGE INTO TLIB.TABLE AS T USING SLIB.TABLE AS S
  ON (T.KEY1 = S.KEY1 AND T.KEY2  = S.KEY2)
WHEN NOT MATCHED THEN
  INSERT VALUES(S.KEY1, S.KEY2, S.FIELD1, S.FIELD1)
WHEN MATCHED THEN
  UPDATE SET ROW = (S.KEY1, S.KEY2, S.FIELD1, S.FIELD1);
-- remove records that are in target file but not source file
DELETE FROM TLIB.TABLE T2
WHERE RRN(T2) IN (
  SELECT RRN(T)
  FROM TLIB.TABLE AS T
  LEFT JOIN SLIB.TABLE AS S
    ON (T.KEY1 = S.KEY1 AND T.KEY2 = S.KEY2)
  WHERE S.KEY1 IS NULL);

MERGE INTO TLIB.TABLE AS T USING (
  select 'SLIB' PROVENANCE, sl.* from SLIB.TABLE sl
  union all select 'TLIB' PROVENANCE, tl.* from TLIB.TABLE TL left join SLIB.TABLE SL on (sl.key1, sl.key2) = (tl.key1, tl.key2) where sl.key1 is null
  ) AS S
  ON (T.KEY1 = S.KEY1 AND T.KEY2  = S.KEY2)
WHEN NOT MATCHED THEN
  INSERT VALUES(S.KEY1, S.KEY2, S.FIELD1, S.FIELD1)
WHEN MATCHED and PROVENANCE = 'SLIB' THEN
  UPDATE SET ROW = (S.KEY1, S.KEY2, S.FIELD1, S.FIELD1)
WHEN MATCHED and PROVENANCE = 'TLIB' THEN
  DELETE;

MERGE INTO TLIB.TABLE AS T USING (
  SELECT S1.*, T1.KEY1 AS TKEY1, T1.KEY2 AS TKEY2
  FROM SLIB.TABLE AS S1
  FULL OUTER JOIN TLIB.TABLE AS T1
    ON T1.KEY1 = S1.KEY1 AND T1.KEY2 = S1.KEY2
  ) AS S ON COALESCE(S.KEY1, TKEY1) = T.KEY1 AND
            COALESCE(S.KEY2, TKEY2) = T.KEY1
WHEN NOT MATCHED THEN
  INSERT VALUES(S.KEY1, S.KEY2, S.FIELD1, S.FIELD1)
WHEN MATCHED AND S.KEY1 IS NULL THEN DELETE
WHEN MATCHED AND S.KEY1 IS NOT NULL THEN 
  UPDATE SET ROW = (S.KEY1, S.KEY2, S.FIELD1, S.FIELD1);