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
