HPE NonStop SQL/MX Error – 4216 The FIRST/ANY n syntax cannot be used with an embedded update or embedded delete statement.

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