-20257 FINAL TABLE IS NOT VALID WHEN THE TARGET VIEW view-name OF THE SQL DATA CHANGE STATEMENT IN A FULLSELECT HAS AN INSTEAD OF TRIGGER DEFINED

Explanation

The fullselect includes an INSERT, UPDATE, or MERGE statement that targets a view that has an INSTEAD OF trigger defined for the SQL data change operation. The FINAL TABLE results of an INSTEAD OF trigger cannot be returned.

System action

The statement cannot be processed.

Programmer response

Drop the INSTEAD OF trigger, and reissue the statement.

SQLSTATE

428G3