logo  
Google
 

DB2 SQL-Error: -118

SQLState: 42902

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

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. System action: The statement cannot be executed. No data was updated or deleted. Programmer response: 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.

 <-  BACK TO INDEX