Start of change

-20094   THE COLUMN column-name IS A GENERATED COLUMN AND CANNOT BE USED IN THE BEFORE TRIGGER trigger-name.

Explanation

The value for the indicated column is generated using an expression and cannot be named in the column name list of a BEFORE UPDATE trigger or set in a BEFORE trigger.

column-name
The name of the column.
trigger-name
The name of the trigger.

System action

The statement cannot be processed.

User response

Remove either the generated column from the column name list or the SET assignment statement that sets the new transition variable of a generated column, then resubmit the statement.

SQLSTATE

42989

End of change