Skip to Content

Native SQL WHERE fieldname IN(:hostvar)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 02, 2016 at 06:27 PM

    Looks like impossible! Closing the question.

    Add comment
    10|10000 characters needed characters exceeded