Friday 5 May 2017

Combine two DELETE-Statements in node-ibm_db

I would like to delete all entries from several tables using node-ibm_db. When I try the following code, only the first table gets cleaned. I have also tried without the \n and with a space between the statements. Nothing seems to work. I have found that firing two select statements in one call is supported (link to github). Can anyone help me to make that work for two DELETE-Statements, too?

connection.prepare("DELETE FROM xxx.someTable;\nDELETE FROM xxx.someOtherTable;") I execute the prepared statement with executeNonQuery().



via ikorni

No comments:

Post a Comment