In this blog post, let’s learn about the error message “11006 Use of rowsets with statements involving triggers is not supported.NOTE:As of the ABU SPR, this message is no longer generated.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11006 Use of rowsets with statements involving triggers is not supported.NOTE:As of the ABU SPR, this message is no longer generated.
Reason for the Error
Rowsets were used in a statement that is a trigger event.
Solution
Either remove the rowset from the statement or drop all triggers defined on the table and operation that caused the error. For example, if the operation is a delete, drop all delete triggers defined on the DELETE statement target table. If the triggers cannot be dropped, avoid the use of rowsets
