option #23

In‑place MERGE and duplicate records

WTSupported in traditional Synergy on Windows
WNSupported in Synergy .NET on Windows
USupported on UNIX

 

System option #23 determines where the in‑place MERGE statement places duplicate records.

If you set option #23, the in‑place MERGE places duplicate records from the second input file after their matching records from the first input file.

If you don’t set this option, the in‑place MERGE statement places duplicate records from the second file before their matching records from the first file.

For more information about the MERGE statement, see MERGE.