In this blog post, let’s learn about the error message “20100 No value is specified for ‘skip’ in the COLUMN FORMAT of the format file. Column name=columnname.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20100 No value is specified for ‘skip’ in the COLUMN FORMAT of the format file. Column name=columnname.
Reason for the Error
The skip flag was missing for this column from the COLUMN FORMAT section of the format file.
Solution
Set the skip flag to Y or N in the COLUMN FORMAT section of the format file