Common Errors During the Modify Procedure
When using the modify procedure, the most common errors include:
• A “duplicate key” error message when you use the Unique option (or the TO UNIQUE clause of the MODIFY statement).
To resolve this problem, determine which rows have duplicate keys and delete these rows. You can locate these rows with the following query:
select key_col, count(*) as repeat_number
from table_name
group by key_col
having count(*) > 1;
• An error when modifying a table.
You may be out of disk space on the file system the modify procedure is trying to use. Clear up disk space on this file system.