In this blog post, let’s learn about the error message “11014 A BEFORE trigger allows only SIGNAL and SET operations.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11014 A BEFORE trigger allows only SIGNAL and SET operations.
Reason for the Error
You attempted to create a BEFORE trigger with a trigger action other than SIGNAL or SET.
Solution
If SET or SIGNAL does not work, determine whether an AFTER trigger is more appropriate for your application. If an AFTER trigger cannot be used, you will need to implement the action in your application
