Return
-
Title
When altering an index, the script that is created is not complete -
Description
When altering an index, the script that is created is missing some of the components is should have.
The First Problem is that the script does not first DROP the Index Before trying to Create the index with the new column in it.
The second problem is that the Constraint that is going to be built does not have the new column in it. -
Resolution
WORKAROUND:
Manually add the Drop of the index and add the column name in the Add Constraint statement.
STATUS:
Waiting for fix to be released in a future version of Toad for DB2. -
Defect ID
ST72390