In this post, you’ll learn about the error message -118 the object table or view of the insert, delete, or update statement is also identified in a from clause in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-118 the object table or view of the insert, delete, or update statement is also identified in a from clause
Reason for the Error
The table or view specified as the object of an INSERT, 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 an INSERT, UPDATE, or DELETE cannot also be used to supply the values to be inserted or to qualify the rows to be inserted, updated, or deleted.
Solution
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.
