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.
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.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center