In this blog post, let’s learn about the error message “20022 The field length (lengthvalue) for column columnname does not match the required length (requiredlength).” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20022 The field length (lengthvalue) for column columnname does not match the required length (requiredlength).
Reason for the Error
The field length provided in the format file (for binary import) and the field length required by the column are not the same.
Solution
Correct the field length in the format file and resubmit
