HPE NonStop SQL/MX Error – 4026 Reading from and inserting into, or updating in, or deleting from the same table, name, is not currently supported.

In this blog post, let’s learn about the error message “4026 Reading from and inserting into, or updating in, or deleting from the same table, name, is not currently supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4026 Reading from and inserting into, or updating in, or deleting from the same table, name, is not currently supported.

Reason for the Error

You attempted to read from and insert, update, or delete within the same table name. This feature is not supported.

Solution

Correct the syntax and resubmit