Example: Finding Duplicate Keys in a Database File
Command
dbfinddupkeys dbtest80 dbtest1
Results
The utility finds multiple duplicate keys in the index Set2:
File: Dbtest1
Scanning index Set1...
Scanning index Set2... duplicate index key found
Key fields: Mc2
Mc1 Mc2 Mc3 Mc4 Mc5 Mc6 Mc7 Mc8s.Mc8[1] Mc8s.Mc8[2] Mc8s.Mc8[3]
1 A A a 19950701 120001 6124828411 0.10 0.20 0.30
210 A CA aa 19990701 000312 123 12.00 12.00 12.00
211 A CB ab 19900701 000313 124 13.00 13.00 13.00
Number of duplicates: 3
Another duplicate index key found
22 V V v 19950703 120014 6124828432 7.05 7.15 7.25
212 V VV vv 19900703 000413 224 213.00 23.00 23.00
Number of duplicates: 2
Scanning index Set3...
Scanning index Set4...
Scanning index Set5...