HPE NonStop SQL/MX Error – 11021 The subject table name cannot be used in the REFERENCING clause.

In this blog post, let’s learn about the error message “11021 The subject table name cannot be used in the REFERENCING clause.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

11021 The subject table name cannot be used in the REFERENCING clause.

Reason for the Error

You attempted to use the subject table name as a transition variable name.

Solution

Use a different name for the transition variable name and resubmit