In this blog post, let’s learn about the error message “11018 An empty or unsupported trigger action was specified.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11018 An empty or unsupported trigger action was specified.
Reason for the Error
An attempt was made during DDL to create an AFTER trigger with an unsupported action. In particular, this error is raised if the trigger action is a compound statement, an embedded DELETE, or an embedded UPDATE.
Solution
Add an action to the trigger statement and use a supported action for the trigger. Before triggers support only SET and SIGNAL operations, while AFTER triggers support INSERT, UPDATE, DELETE, and SIGNAL operations