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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: