proc sql ERROR: No data found/modified

[havmaage]

Hi Sas, 

when running delete from table thought SQL Passthrough on mssql from OPC batch it errors out 

with ERROR: No data found/modified. 

CONNECT TO ODBC AS PASSTHRU
(noprompt="DRIVER={SQL SERVER};DATABASE=&_DB;Trusted_Connection=Yes;SERVER=&_INC;ansiNPW=yes;ansi_null=YES;autotranslate=yes");

    &SQLINI from connection to passThru (
	DELETE FROM SQL.TESTTABLE
	
 );

DISCONNECT FROM passThru;

i have notice that it has been mensioned in the past and there should be a hotfix 

https://support.sas.com/kb/42/537.html

But as for now this is not an option. Does anybody know of any workound to avoid this. 

[ChrisNZ]

1. What's variable SQLINI ?   You need an execute by  statement here, not a select ... from statement.

[havmaage]

Oh sorry &SQLINI has a text string value (select * from )

[ChrisNZ · Accepted solution]

As I said that's incorrect.