I'm trying to insert and drop rows over an ODBC connection. My Insert block works fine, and I'd hoped the drop would work the same, but I get the following error in my SAS log when trying to drop the row I just inserted:
ERROR: Updating or deleting data cannot be supported by this engine when a WHERE clause and the DBCOMMIT option are used together
proc sql; insert into sql_meta.dash_meta_dates SELECT * FROM WORK.test; proc sql; delete from sql_meta.dash_meta_dates where GROUP_AE_REGISTRY = "Test";
Solved my own problem.
I had to comment out the DBCOMMIT portion of my ODBC conneciton:
*Libname for the meta dashboard dates table;
LIBNAME SQL_META ODBC DSN="Dash" DATABASE="QA" SCHEMA=dbo
READBUFF=4000 INSERTBUFF=4000 /*DBCOMMIT=4000*/
;
Solved my own problem.
I had to comment out the DBCOMMIT portion of my ODBC conneciton:
*Libname for the meta dashboard dates table;
LIBNAME SQL_META ODBC DSN="Dash" DATABASE="QA" SCHEMA=dbo
READBUFF=4000 INSERTBUFF=4000 /*DBCOMMIT=4000*/
;
Please update your post as answered in that case to avoid us checking it to see if you still need help or not.
This was my first post, so I didn't know to do that. Thanks.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.