14
Attempt to insert duplicate key row in object '%.*s' with unique index '%.*s'%S_EED
No two rows can have the same index value (including NULL) in a column or columns with a unique index. Adaptive Server checks for duplicate values when the index is created (if data already exists) and checks each time data is added with an insert or update. Error 2601 occurs when you try to put duplicate index values into a column or columns with a unique index.
Using a unique index makes sense only when uniqueness is a characteristic of the actual data. Choose one of the following solutions, depending on whether you need a unique index:
If you need duplicate index values in indexed columns, drop the unique index and create a nonunique index instead.
If you need a unique index on data that contains duplicate values, you must change some values to remove the duplicates:
Use a select statement to find the row that will be duplicated by the update or insert command.
Modify either the data in the table or the data that you want to insert, so that the index values do not match.
Refer to “create index” in the Reference Manual: Commands for information.
All versions
