I am executing sql statements in MaxDB 7.6.04.12 from java using jdbc.
I want to execute multiple statements at a time, but it seems that however I separate the statements, I get
com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3014] (at 433): Invalid end of SQL statement
I have tried separating the statements with just a semi-colon, with a semi-colon and new line, with newline-//-newline (as works with SQL Studio), but whatever I try I get this error or some other.
Is it possible to do this? and if so how?
Thanks
Chris