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