THE OBJECT TABLE OR VIEW OF THE DELETE OR UPDATE STATEMENT IS ALSO IDENTIFIED IN A FROM CLAUSE

Conclusão: The table or view specified as the object of a DELETE or UPDATE statement also appears in the FROM clause of a subselect within the statement.

The table or view that is the object of a UPDATE or DELETE cannot also be used to supply the values to be inserted or to qualify the rows to be updated or deleted.

Ação do sistema: O comando não pode ser executado. Nenhum dado foi alterado ou deletado.

Resposta ao Desenvolvedor: The implied function is not supported by DB2. It may be possible to obtain the desired result by creating a temporary copy of the object table or view and addressing the subselect to that copy. Refer to Chapter 5 of DB2 SQL Reference for information about the syntax of SQL statements.

SQLSTATE: 42902