-614   THE INDEX CANNOT BE CREATED OR ALTERED, OR THE LENGTH OF A COLUMN CANNOT BE CHANGED BECAUSE THE SUM OF THE INTERNAL LENGTHS OF THE COLUMNS FOR THE INDEX IS GREATER THAN THE ALLOWABLE MAXIMUM

Explanation

The index could not be created or the length of a column cannot be changed because the sum of the internal lengths of the key columns would exceed the allowable maximum. The maximum permitted key length is as follows:
  • For PADDED indexes, the sum of the length attributes of the columns must not be greater than 2000-n, where n is the number of columns that contain null values.
  • For NOT PADDED indexes, the sum of the length attributes of the columns must not be greater than 2000-n-2m, where n is the number of nullable columns and m is the number of varying length columns.

System action

The statement cannot be processed. The specified index was not created or the length of the column was not changed.

Programmer response

The definition for the index must be modified (possibly by eliminating one or more key columns) to reduce the length of the key to the permitted maximum.

SQLSTATE

54008