HPE NonStop SQL/MX Error – 1130 The column requires a default value.

In this blog post, let’s learn about the error message “1130 The column requires a default value.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1130 The column requires a default value.

Reason for the Error

You attempted to create a column that requires a default value, without specifying a default value.

Solution

Specify a valid default value for the column and resubmit