KFAA30659-E
The value specified in the CHANGE clause of the ALTER TABLE statement is invalid. (reason = aa....aa) (M+J+O)
The data type and data length specified in the ALTER TABLE statement CHANGE clause is invalid. <SQLSTATE: 42I27>
- aa....aa:
-
Cause of the error
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Take corrective action as described in the following table: Then, re-execute the ALTER TABLE statement.
Information output to aa....aa
Cause of the error
Corrective action to take
the data type that cannot be changed is specified
The data type that was specified cannot be changed.
Specify the CHANGE clause so that is becomes one of the following combinations.
-
Specifying a VARCHAR type column with a data length of 254 bytes or less as the column name in the CHANGE clause
For the data type after the change, specify the VARCHAR type with a data length of 255 bytes or less.
-
Specifying a VARCHAR type column with a data length of 256 bytes or more and 31,999 bytes or less as the column name in the CHANGE clause
For the data type after the change, specify the VARCHAR type with a data length of 32,000 bytes or less.
the specified data length after the change is shorter than the data length before the change
The data length of the changed data type is specified to be shorter than the data length before the change.
The data length of the data type after the change must be longer than the data length before the change.
-