Native SQL WHERE fieldname IN(:hostvar)

[former_member186338]

Is it possible to pass to Native SQL the host variable containing list of values to be used in:

DELETE FROM tablename WHERE field IN(:hostvariable)

resulting in:

DELETE FROM tablename WHERE field IN('2015.02','2015.03','2015.04')

My external server is MS SQL server

I know about other ways to achieve the goal...

- Loop DELETE

- Run stored procedure

- Use dynamic ADBC

[former_member186338]

Looks like impossible! Closing the question.