In this blog post, let’s learn about the error message “4107 Column name has no default value, so DEFAULT cannot be specified.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4107 Column name has no default value, so DEFAULT cannot be specified.
Reason for the Error
In the source value list of INSERT, you specified DEFAULT for column name, but there is no default value for that column.
Solution
Correct the syntax and resubmit
