In this blog post, let’s learn about the error message “4216 The FIRST/ANY n syntax cannot be used with an embedded update or embedded delete statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4216 The FIRST/ANY n syntax cannot be used with an embedded update or embedded delete statement.
Reason for the Error
You attempted to use either a FIRST n or an ANY n clause in an embedded UPDATE or DELETE statement.
Solution
Remove the FIRST n or ANY n clause and resubmit