HPE NonStop SQL/MX Error – 4088 The number of values in each TRANSPOSE item of a TRANSPOSE set must be equal.

In this blog post, let’s learn about the error message “4088 The number of values in each TRANSPOSE item of a TRANSPOSE set must be equal.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4088 The number of values in each TRANSPOSE item of a TRANSPOSE set must be equal.

Reason for the Error

You specified a TRANSPOSE set with an unequal number of values in each TRANSPOSE item.

Solution

Correct the syntax and resubmit