I got below mentioned error while updating a View in DB2.
42807(-150)[IBM][CLI Driver][DB2/SUN64] SQL0150N The target fullselect, view, typed table, materialized query table, or staging table in the INSERT, DELETE, UPDATE, or MERGE statement is a target for which the requested operation is not permitted. SQLSTATE=42807
As the error suggest administrator have not given update permission to the user. Ask administrator to give access, else it would not be possible.
42807(-150)[IBM][CLI Driver][DB2/SUN64] SQL0150N The target fullselect, view, typed table, materialized query table, or staging table in the INSERT, DELETE, UPDATE, or MERGE statement is a target for which the requested operation is not permitted. SQLSTATE=42807
As the error suggest administrator have not given update permission to the user. Ask administrator to give access, else it would not be possible.
