Deleting rows from DB2 using DI STUDIO

[MattiL]

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?

br

Matti 

[ChrisNZ]

Any log report of your attempts that we could see ?

[LinusH · Accepted solution]

Have you tried to specify 0?