In this blog post, let’s learn about the error message “3216 Computed LONG WVARCHAR length value1 is below minimum value2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3216 Computed LONG WVARCHAR length value1 is below minimum value2.
Reason for the Error
You attempted a CREATE TABLE table name (c1 longwvarchar, c2 longwvarchar,…cn longwvarchar) and the computed width for each of the longwvarchar columns falls below the current MIN_LONG_WVARCHAR_DEFAULT_SIZE setting.
Solution
Reduce the number of longwvarchar columns in the CREATE TABLE statement or increase the current MIN_LONG_WVARCHAR_DEFAULT_SIZE setting and resubmit