Prolog:
Here is a similar discussion for a single statement:
Export CSV in a planified task with a Batch working with SQLCL (0 Bytes)
On a windows machine I want to
create a SQL-file with a statement for "spool ... select ..", stored in "my_statement.sql"
call it from Windows with a batch-file which contains the commands ..
connect to database
call and run the SQL file
disconnect from database
If possible / better I can also connect and disconnect manually, but when it is connected I should call an SQL-file next to the other. Here I would call a software like Autohotkey which fires the batch(es) immediately when they are created.
Is it possible? How?
Thanks for help!