In this blog post, let’s learn about the error message “4060 Reading from and inserting, or updating in, or deleting from the same table,name1 ,is not currently supported.name1 is contained by view(s)name2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4060 Reading from and inserting, or updating in, or deleting from the same table,name1 ,is not currently supported.name1 is contained by view(s)name2.
Reason for the Error
You attempted to read from and insert, update, or delete within the same table name1, which is not supported.
Solution
Correct the syntax and resubmit