DWSQLTool   v0.0.1 ALPHA

for tweaks see doc/ folder.


DWSQLTool (Data Warehouse SQL Tool) is a command line database query tool, designed for rapid prototyping and easy automation of database access.

By default, the tool is quiet, and only outputs the results of queries.

To run it in console mode:


dwsqltool db=dbname user=dbuser pass=dbpass console head -


The parameter structure is modeled after Oracle's sqlplus, ie:

def myvar='somevalue';

select * from blah where glah='&&myvar';





WINDOWS INSTALLATION ISSUES

In order for everything to work, you need to set:

DWSQLTOOL_HOME environment variable, ie:

SET DWSQLTOOL_HOME=c:\jdk\DWSQLTool

Or right-click on 'My Computer', go to 'Properties', then 'Advanced', then 'Environment Variables', and add a new environment variable DWSQLTOOL_HOME, with value being the directory where DWSQLTool is installed.



