HPE NonStop SQL/MX Error – 4107 Column name has no default value, so DEFAULT cannot be specified.

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