In this blog post, let’s learn about the error message “3209 Maximum length of LONGWVARCHAR is value.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3209 Maximum length of LONGWVARCHAR is value.
Reason for the Error
You attempted a CREATE TABLE table name (columnname longwvarchar(N)) where N > current MAX_LONG_WVARCHAR_DEFAULT_SIZE setting.
Solution
Decrease the CREATE TABLE statement’s longwvarchar column width N or increase the current MAX_LONG_WVARCHAR_DEFAULT_SIZE setting and resubmit
