KFAA30665-E
The ALTER TABLE statement could not be used to change the column attributes, because the current aa....aa and the new aa....aa are the same. (M+J+O)
Because the specified values before and after changing are the same, it is not possible to change the column attributes (maximum number of elements or data length) using the ALTER TABLE statement. <SQLSTATE: 42I31>
- aa....aa: Invalid specification
-
-
maximum number of elements: The maximum number of elements
-
data length: The data length
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Take one of the following corrective actions:
-
If aa....aa is maximum number of elements
Re-execute the ALTER TABLE statement with a value greater than the maximum number of elements before the change.
-
If aa....aa is data length
Re-execute the ALTER TABLE statement with a value greater than the data length before the change as the data length of the changed data type.
-