HPE NonStop SQL/MX Error – 4235 seq-pseudo-col cannot be used in aggregate function, union, where, HAVING clause, WHEN clause, case expression, or procedure parameter list.

In this blog post, let’s learn about the error message “4235 seq-pseudo-col cannot be used in aggregate function, union, where, HAVING clause, WHEN clause, case expression, or procedure parameter list.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4235 seq-pseudo-col cannot be used in aggregate function, union, where, HAVING clause, WHEN clause, case expression, or procedure parameter list.

Reason for the Error

You compiled a query which contains Sequence Generator pseudo column in an aggregate function, HAVING clause, CASE expression, or procedure parameter list.

Solution

Modify the statement and resubmit