Peter Eisentraut writes:> Jim Buttafuoco writes:> > I agree with Lee, I also like Oracle's options for a discard file,
so>> you can look at what was rejected, fix your problem and reload if> > necessary just the rejects.> How do you know
whichone is the duplicate and which one is the good one?> More likely you will have to fix the entire thing. Anything
elsewould> undermine the general data model except in specific use cases.
In the general case most data is sequential, in which case it would be
normal to assume that the first record is the definitive one. Most
database systems go with this assumption apart from MySQL which gives
the user a choice between IGNORE or UPDATE...
Lee.