Running sql script from Ignition

JDBC doesn't officially support SQL scripts. Just statements. Some JDBC drivers implement some SQL scripting syntax, but you are kind of on your own. If you really need to run a script in your DB, use a stored procedure. An SP can be called with a single statement.

2 Likes