Duplicate records in a keyed physical file
Would journaling over a multiple member physical file cause duplicate records? The DDS of the file does not have UNIQUE.
Software/Hardware used:
Software/Hardware used:
ASKED:
February 1, 2013 3:06 PM
UPDATED:
February 1, 2013 3:51 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
Michael Tidmarsh 
11,410 pts. ,
Mcrews 25 pts.
11,410 pts. ,
Mcrews 25 pts. To see all answers submitted to the Answer Wiki: View Answer History.
No. journaling captures what has happened to the file in the receiver, it does not put records into the file.
The journal should be able to help you identify how/when the duplicates were put into the file.
Journaling by itself would have no effect on creation nor existence of duplicate records. Journaling doesn’t create records at all. However, by reviewing journal entries, you can find where duplicates are coming from. Duplicates are allowed in the file if the UNIQUE attribute isn’t set. — Tom
GIWIST
Journaling just provides an audit trail of actions on the file. It does no adding of data. If duplicates are an issue them ypu need to make the file key “unique”