[h2] Re: Console or Shell: Run a query from a script file and capture output

Update: I found how to run Runscript from a terminal with suitable arguments to run the query from a file and capture the results. Good. I still cannot see whether there is a way to do this from the Console. It appears not, is that right? -- You received this message because you are

Re: [h2] Re: Console or Shell: Run a query from a script file and capture output

If it is a small script you can copy paste the script in I think. If you want to run from a file then issue the RUNSCRIPT sql command. If it is on a server, the script needs to be accessible on the server and use a path as it would be on the server.