In this blog post, let’s learn about the error message “11061 Nested and Union queries are currently not supported in WHEN clause of AFTER trigger.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11061 Nested and Union queries are currently not supported in WHEN clause of AFTER trigger.
Reason for the Error
The WHEN clause consists of queries that are nested or union statements.
Solution
Use only a simple one-level query in the WHEN clause
