HPE NonStop SQL/MX Error – 20086 Column columname in the FIXED WIDTH FORMAT part of the format file is not found in the target table. Key = keyval

Data 9 Views 1 Min Read

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

Tags: