Interactive SQL for Windows

Installing Database DriversCopy jar file(s) into root folder or modify DRIVER_CLASSPATH to point to jar's location and start application.

For legal reasons, Database Drivers are not supplied with the application. They can be downloaded from the links below.

WindowsUsage: isqlc.cmd [[user password] [-i file]]

Unix basedUsage: ./isqlc.sh [[user password] [-i file]]

user - database user namepassword - user's passwordfile - file containing SQL queries

When -i is used, no banner is displayed and the application exits after the batch is complete.

ConfigurationJAVA_HOME - location where JRE is installedDRIVER_CLASSPATH - location of database driver(s)CONFIG_LOCATION - location of config.properties file

Config.properties filemax_text - display size of character fieldscomment - line comments markerbatch_separator - delimiter between commandsdriver - database driver classconnString - java connect string

Example:max_text=60comment=--batch_separator=;driver=com.microsoft.sqlserver.jdbc.SQLServerDriverconnString=jdbc:sqlserver://123.456.789.007:1433;DatabaseName=somedatabase

Block comments marker is the standard /* */.

Database Drivers DownloadMSSQL Server: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774ORACLE: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.htmlSybase: http://www.sybase.com.au/products/allproductsa-z/softwaredeveloperkit/jconnectMySQL: http://dev.mysql.com/downloads/connector/j/