Using difference files with TBEXEC

TBCOMP analyzes the differences between tables by treating the first table as the new table and the second table as the old table. The two difference files that are generated when applied to the old table cause it to be identical to the new table. This is not the only way to apply the differences files, however the example below demonstrates how to update the old to bring it up to the new.

The first unload file contains rows which should be deleted from the second target table. The second unload file contains rows which should be inserted/replaced in the second target table. If rows with identical keys but different contents outside the keys are found in both the new and the old tables, then records will be created in both the first and second unload file. Therefore, deletes must be applied before updates. Please see the following example: