In this blog post, let’s learn about the error message “4512 Invalid correlation name specified for the USING clause.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4512 Invalid correlation name specified for the USING clause.
Reason for the Error
You specified the same correlation name for the target table and the subquery of the USING clause.
Solution
Modify the correlation name of the target or the source table and resubmit the statement