ContentsIndexPreviousNext

DUPLICATES_LOG

This variable is used during bulk addition of Vision files. It causes Vision to write files rejected for having illegal duplicate keys to a log file. Set DUPLICATES_LOG to the name of a file in which to store the records. If this log file already exists, it will be overwritten. You must use a separate log file for each file opened with bulk addition. You can do this by changing the setting of DUPLICATES_LOG between OPEN statements, as follows:

SET ENVIRONMENT "DUPLICATES_LOG" TO "file1.rej"
OPEN OUTPUT FILE-1 FOR BULK-ADDITION

SET ENVIRONMENT "DUPLICATES_LOG" TO "file2.rej"
OPEN EXTEND FILE-2 FOR BULK-ADDITION

If no duplicate records are found, the log file is removed when the Vision file is closed. If DUPLICATES_LOG has not been set, or is set to spaces, then no log file is created.


Note: The duplicate-key log file may not be placed on a remote machine using AcuServer. The log file must be directly accessible by the machine that is running the program.
See Section 6.1.6.3 "Bulk Addition Mode for Vision" in the User's Guide for instructions on how to read the log file.