HPE NonStop SQL/MX Error – 4056 Exposed name name appears more than once.

Data 6 Views 1 Min Read

In this blog post, let’s learn about the error message “4056 Exposed name name appears more than once.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4056 Exposed name name appears more than once.

Reason for the Error

You specified a statement with an exposed table name that appears more than once. For example:

SELECT * FROM tblx, tblx;

Solution

Correct the syntax and resubmit

Tags: