In this blog post, let’s learn about the error message “11037 A trigger cannot be defined on a view!” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11037 A trigger cannot be defined on a view!
Reason for the Error
You attempted to create a trigger on a view.
Solution
Abandon the operation or create a trigger on one of the view-based tables, if this is applicable to your application