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).

Data 11 Views 1 Min Read

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

Tags: