HPE NonStop SQL/MX Error – 20151 IMPORT does not currently support binary data files.

In this blog post, let’s learn about the error message “20151 IMPORT does not currently support binary data files.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20151 IMPORT does not currently support binary data files.

Reason for the Error

The format file has a line that specifies FileIsBinary=Y.This option is not supported in the current release of NonStop SQL/MX.

Solution

Change the format file to specify FileIsBinary=N and resubmit