You can translate the question and the replies:

execute a SQLfile from scheduler

SQL file has multiple update statements and insert statements, how can i run this SQL file from scheduler?
21-11-2016 10:16:55 -0500

1 Answer

Hi, I generally create a CSV file with all the SQL statements to be executed on the relational database. Next using Denodo scheduler I create a CSV data source to point to my CSV file previously created and a JDBC data source to connect to my relational data source. Finally create a JDBC type job in Denodo scheduler with parameterized query like @sqlcommands also add the CSV source to the JDBC job. Using these steps I am able to execute SQL statements over my realtional data sources using Denodo Scheduler. Hope this helps!
Denodo Team
30-11-2016 06:40:00 -0500
You must sign in to add an answer. If you do not have an account, you can register here