Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Multiple DELETE statements in a single query in Cache Monitr

Question
Evgenii Ermolaev · Oct 23, 2021

Multiple DELETE statements in a single query in Cache Monitr

I need to execute multiple DELETE statements in a single query like this

DELETE FROM TableName WHERE ID = 2;
DELETE FROM TableName WHERE ID = 3;
DELETE FROM TableName WHERE ID = 4;

However It does not work when there're more than 2 statements and gives me an error

Expected FROM found WHERE^DELETE FROM TableName WHERE

Using IN is not an option.

#SQL #Caché
Product version: Caché 2018.1

Source URL:https://community.intersystems.com/post/multiple-delete-statements-single-query-cache-monitr