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