KFAA30667-E

The maximum number of elements specified in the CHANGE clause of the ALTER TABLE statement are invalid. <SQLSTATE: 42I32>

aa....aa: Cause of the error

• the new value is less than the current value:

  An attempt was made to make the maximum number of elements smaller than before the change.

• the data type of the target column is not the array type:

  An attempt was made to change the maximum number of elements in a column that is not an array type.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Take one of the following corrective actions based on the cause of the error that is output:

• If the new value is less than the current value

  Re-execute the ALTER TABLE statement with a value greater than the maximum number of elements before the change.

• If the data type of the target column is not the array type

  Specify the array-type column name in the CHANGE clause and re-execute the ALTER TABLE statement.