https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-where-fieldname-in-hostvar/m-p/332683#M5517 <P>Is it possible to pass to Native SQL the host variable containing list of values to be used in:</P><P>DELETE FROM tablename WHERE field IN(:hostvariable)</P><P>resulting in:</P><P>DELETE FROM tablename WHERE field IN('2015.02','2015.03','2015.04')</P><P>My external server is MS SQL server</P><P>I know about other ways to achieve the goal...</P><P>- Loop DELETE</P><P>- Run stored procedure</P><P>- Use dynamic ADBC</P> Sun, 21 Jan 2024 22:20:24 GMT former_member186338 2024-01-21T22:20:24Z https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-where-fieldname-in-hostvar/m-p/332683#M5517 <P>Is it possible to pass to Native SQL the host variable containing list of values to be used in:</P><P>DELETE FROM tablename WHERE field IN(:hostvariable)</P><P>resulting in:</P><P>DELETE FROM tablename WHERE field IN('2015.02','2015.03','2015.04')</P><P>My external server is MS SQL server</P><P>I know about other ways to achieve the goal...</P><P>- Loop DELETE</P><P>- Run stored procedure</P><P>- Use dynamic ADBC</P> Sun, 21 Jan 2024 22:20:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-where-fieldname-in-hostvar/m-p/332683#M5517 former_member186338 2024-01-21T22:20:24Z https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-where-fieldname-in-hostvar/m-p/332684#M5518 <P>Looks like impossible! Closing the question.</P> Fri, 02 Dec 2016 18:27:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/native-sql-where-fieldname-in-hostvar/m-p/332684#M5518 former_member186338 2016-12-02T18:27:02Z