In this blog post, let’s learn about the error message “11019 Only statement triggers can scan the transition table.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11019 Only statement triggers can scan the transition table.
Reason for the Error
You attempted to create a row trigger that has a scan of the transition table either in its action or in its condition.
Solution
Depending on your application, you can either recreate the trigger as a statement trigger, or scan from the subject table
