HPE NonStop SQL/MX Error – 3215 Computed LONG VARCHAR length len1 is below minimum len2.

Data 20 Views 1 Min Read

In this blog post, let’s learn about the error message “3215 Computed LONG VARCHAR length len1 is below minimum len2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3215 Computed LONG VARCHAR length len1 is below minimum len2.

Reason for the Error

You attempted a CREATE TABLE table name (c1 longvarchar, c2 long varchar,…cn long varchar) and the computed long varchar columns’ width is below the current MIN_LONG_VARCHAR_DEFAULT_SIZE setting.

Solution

Decrease the number of long varchar columns in the CREATE TABLE statement or increase the current MIN_LONG_VARCHAR_DEFAULT_SIZE setting and resubmit

Tags: