In this blog post, let’s learn about the error message “20070 Columns in the datafile are not correct. Columns found so far: columnnumber” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20070 Columns in the datafile are not correct. Columns found so far: columnnumber
Reason for the Error
The specific field in the current row in the input file could not be processed.
Solution
Check the specified column in the current row for valid data