HPE NonStop SQL/MX Error – 11019 Only statement triggers can scan the transition table.

Data 19 Views 1 Min Read

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

Tags: