In this blog post, let’s learn about the error message “11001 There are more than 256 triggers in this statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11001 There are more than 256 triggers in this statement.
Reason for the Error
More than 256 triggers were encountered during the statement compilation, which is not supported.
Solution
Either rewrite the statement so that fewer triggers are generated, or redesign the triggers so that the triggering graph is not as deep