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";
... View more
