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
Any log report of your attempts that we could see ?
Have you tried to specify 0?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.