|
|
|
Junior Member
 
Group: Forum Members
Last Login: 1/4/2007 4:44:00 AM
Posts: 22,
Visits: 1
|
|
All
waiting for the kind response of all friends
1- How to stop the insert of duplicate value in a table.
2- If fast load failed inserting the duplicate value in a table how this problem will be resolved.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/3/2006 6:08:00 AM
Posts: 2,
Visits: 1
|
|
hello,
If you want to stop loading duplicate values for a particular column make that column a unique primary index.
manja
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 10/12/2006 2:51:00 PM
Posts: 68,
Visits: 1
|
|
Hi,
are you thinking about duplicate rows or duplicate PI values?
If you're thinking about duplicate rows, then you'll probably have a multiset table with a NUPI on it.
1- if you don't want to have duplicate rows in a table convert your table to set and/or put a UPI (or also a USI) on it.
2- fastload automatically discards perfectly duplicated rows. if you want to load them in a table you have to use another utility, for example multiload.
If you're thinking about duplicate values for the PI:
1- if you don't want to have duplicate values put a UPI on your table
2- using fastload it will automatically discard duplicate PI values and put them in errortable 1. have a look to the manuals.
Hope this helps,
Bye,
TDUser
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 7/5/2009 2:58:22 PM
Posts: 134,
Visits: 13
|
|
You may do a INSERT..SELECT from a MULTISET (duplicate rows) to a SET table for ignoring duplicates.
Fastload can kickout the duplicates while MLOAD has "IGNORE DUPLICATE" option which can be used.
You may want to check Load and Unload utilities manual for exact symantics.
Vinay
|
|
|
|