11. Maintaining Storage Structures : Modify Procedures : Common Errors During the Modify Procedure
 
Share this page                  
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.