In this blog post, let’s learn about the error message “4514 Sequence functions are not allowed in the ON/UPDATE/INSERT clause of the MERGE statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4514 Sequence functions are not allowed in the ON/UPDATE/INSERT clause of the MERGE statement.
Reason for the Error
Sequence functions CURRVAL and NEXTVAL are not allowed in the ON, UPDATE, or INSERT clauses of the MERGE statement.
Solution
None
