HPE NonStop SQL/MX Error – 4023 The degree of each row value constructor (value) must equal the degree of the target table column list (value).

In this blog post, let’s learn about the error message “4023 The degree of each row value constructor (value) must equal the degree of the target table column list (value).” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4023 The degree of each row value constructor (value) must equal the degree of the target table column list (value).

Reason for the Error

You specified a statement, such as INSERT, in which arow value constructor does not equal the degree of the target table column list. For example:

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

is wrong because the number of columns does not match the number of values.

Solution

Correct the syntax and resubmit