Skip to Content
0

Native SQL WHERE fieldname IN(:hostvar)

Oct 21, 2016 at 04:44 PM

89

avatar image

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

10 |10000 characters needed characters left characters exceeded

Looks like impossible! Closing the question.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers