In this blog post, let’s learn about the error message “20086 Column columname in the FIXED WIDTH FORMAT part of the format file is not found in the target table. Key = keyval” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20086 Column columname in the FIXED WIDTH FORMAT part of the format file is not found in the target table. Key = keyval
Reason for the Error
You specified an invalid column name for one of the columns in the FIXED WIDTH FORMAT part of the format file.
Solution
Verify and correct the column name in the FIXED WIDTH FORMAT part of the format file and resubmit
