Data editing > How Quantum reads data > Merging data files > Merging a field of data from an external file > Errors
 
Errors
Errors can occur if your run contains a mergedata statement and either the main data file or the file of supplementary data for merging has records with duplicate keys or records that are out of sequence. In some cases the run is also canceled after all data has been read, when a complete error report is available. The following table lists the situations when duplicate or out of sequence data may occur and shows what happens to your job.
Circumstance
Message
Run canceled?
read=0 and the main data file contains records with duplicate keys
WARNING: FILE name CONTAINS DUPLICATES IN key_field
No
read=2 and the main data file contains records with duplicate keys
WARNING: FILE name CONTAINS DUPLICATES IN key_field
Yes
read=0 or read=2 and the supplementary data file contains records with duplicate keys
WARNING: FILE name CONTAINS DUPLICATES IN key_field
Yes
read=0 or read=2 and records in the main data file are out of sequence
WARNING: FILE name OUT OF SEQUENCE IN key_field
Yes
read=0 or read=2 and records in the supplementary data file are out of sequence
WARNING: FILE name OUT OF SEQUENCE IN key_field
Yes
See also
Merging a field of data from an external file