HPE NonStop SQL/MX Error – 4024 Column name has no default value, so it must be explicitly specified in the insert column list.

In this blog post, let’s learn about the error message “4024 Column name has no default value, so it must be explicitly specified in the insert column list.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4024 Column name has no default value, so it must be explicitly specified in the insert column list.

Reason for the Error

You attempted to insert column name into a table, and the column has no default value. For example:

INSERT INTO table (acol, bcol, ccol) VALUES (1, 2);

is wrong if ccol does not have a default value and you did not specify its value. The column list is optional, but if you use it, you must explicitly specify values for columns that do not have default values.

Solution

Correct the syntax and resubmit