option #23

In-place MERGE and duplicate records

WSupported on Windows
USupported on Unix

 

NSupported in Synergy .NET

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.