HPE NonStop SQL/MX Error – 11011 Only an UPDATE trigger may specify explicit columns.

In this blog post, let’s learn about the error message “11011 Only an UPDATE trigger may specify explicit columns.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

11011 Only an UPDATE trigger may specify explicit columns.

Reason for the Error

You attempted to create an INSERT or DELETE trigger that has an explicit column list.

Solution

Specify a trigger without the explicit column list