Show TOC

-7046: Column with length greater than 254 not allowedLocate this document in the navigation structure

Use

Explanation

The attempt was made to use a CHAR type column with a length greater than 254 in a statement part that does not allow such a column. This could have happened, for example, if the attempt was made to change a column with a defined length less than 254 into a column with a defined length greater than 254.

User Response

Do not use this column in the statement part. Try to achieve the desired effect by application programming. For a change in the defined length, the desired effect could be achieved by replacing the ALTER definition with a MODIFY definition. Expect this to take significantly longer though. The time required depends on the number of data records in the addressed table and the indexes defined for this table.