HOW TO: Execute multiple commands from a file in EXASOL

In Exaplus we can execute multiple commands, by hitting the Execute All button, or by pressing CTRL + SHIFT + ENTER.

But what if we have a file of multiple commands? Should we copy the contents out and then execute them? Seems a bit of a faff.

Enter the @ command. Or also the START command, but I prefer @. A bit more catchy!

To run commands from a file in Exaplus, run the following:

@C:\folder\myfile.sql;

or if your file resides on FTP:

@ftp://my:ftp@ftp.scripts/myfile.sql;

I’ve found this command to be really handy, particularly in developing my own ‘automated deployment and comparison tool’ for Exasol. But that’s for another day!

Link

Another GUI, another blog

HNY2017

First off, Happy New Year from me in France! I’m out in Les Arcs, skiing for the week (best way to start the year back at work if you ask me!!).

So, in my round up of 2016, I promised you a look at a blog written by one of the guys on my team at Atheon. Vinit has written in his blog about another GUI which can interface with Exasol. An alternative to Exaplus if you will. And, best of all it comes with intellisense! I’ll let Vinit tell you the rest over at his blog optimumretrieval.

 

Error “Can not find the Java Runtime Environment needed by EXAplus GUI. Trying to use system wide virtual machine (from registry) instead. No 64 bit java virtual machine found in registry.”

Don’t you just love that new machine setup process…said nobody ever. Today I got hold of my new machine at work (which is great, thanks guys!). First job is to get all of the programs on that I need.

After the essentials, I got round to installing Exaplus. You can get it from here

I ran the install and got this error on completion:

Can not find the Java Runtime Environment needed by EXAplus GUI. Trying to use system wide virtual machine (from registry) instead. No 64 bit java virtual machine found in registry.

This rang a bell, and was quite similar to this error I’ve had before.

This time round, it was because I didn’t have the 64 bit Java. To fix it, I got the 64 bit download for Java from here.

The install did not fail, it was just the opening of Exaplus that was causing the error. With 64 bit Java installed, Exaplus loaded fine.,