Ignoring duplicate rows during SQL Load [message #72114] |
Tue, 11 March 2003 20:30 |
Ravi Swaminathan
Messages: 1 Registered: March 2003
|
Junior Member |
|
|
Is there away I can check if the value of the table's field I am loading into has the same value in the datafile, duting SQL Load?
For instance, I have a customer number and a date field in the table I am loading into. Is there a way I can check if the combination of these two fields in the data file exists in the table before attempting to load?
The reason is, I have a unique constraint on customer number and the date field. But each row of the data file has three sets of customer number and date values that I have to load as three separate rows. If a duplicate is encountered in a record in one row, the whole row is rejected.
Thanks
|
|
|
|