Deleting rows from DB2 using DI STUDIO

MattiL — Mon, 31 May 2021 08:38:57 GMT

Hi,

Could someone help me with DB2 issue

I get the following error message when i try to execute a delete statement in proc sql;

ERROR: Updating or deleting data cannot be supported by this engine when a WHERE clause and the DBCOMMIT option are used together.

DBCOMMIT is by default: DBCOMMIT=10000

I tried to write a new libname statement without specifying commit point but still got the same error.

Anyone have an idea how to be able to execute the proc sql delete statement to db2?

Matti

Re: Deleting rows from DB2 using DI STUDIO

ChrisNZ — Mon, 31 May 2021 08:46:08 GMT

Any log report of your attempts that we could see ?

LinusH — Mon, 31 May 2021 08:49:48 GMT

Have you tried to specify 0?