In this blog post, let’s learn about the error message “20099 Column columnname defined as NOT NULL NO DEFAULT cannot be skipped.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20099 Column columnname defined as NOT NULL NO DEFAULT cannot be skipped.
Reason for the Error
The skip flag for this column in the COLUMN FORMAT section of the format file was set to Y, but the column was defined as NOT NULL NO DEFAULT and, therefore, cannot be skipped.
Solution
Set the skip flag to Y or N in the COLUMN FORMAT section of the format file
