Installation Copy and unzip in a folder. For Unix based OS run mkfile(./mkfile). It will create isqlc.sh, which is the start up file for the application.
Installing Database Drivers Copy 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.
Windows Usage: isqlc.cmd [[user password] [-i file]]
Unix based Usage: ./isqlc.sh [[user password] [-i file]]
user - database user name password - user's password file - file containing SQL queries
When -i is used, no banner is displayed and the application exits after the batch is complete.
Configuration JAVA_HOME - location where JRE is installed DRIVER_CLASSPATH - location of database driver(s) CONFIG_LOCATION - location of config.properties file
Config.properties file max_text - display size of character fields comment - line comments marker batch_separator - delimiter between commands driver - database driver class connString - java connect string
Example: max_text=60 comment=-- batch_separator=; driver=com.microsoft.sqlserver.jdbc.SQLServerDriver connString=jdbc:sqlserver://123.456.789.007:1433;DatabaseName=somedatabase
Block comments marker is the standard /* */.
Database Drivers Download MSSQL Server: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 ORACLE: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html Sybase: http://www.sybase.com.au/products/allproductsa-z/softwaredeveloperkit/jconnect MySQL: http://dev.mysql.com/downloads/connector/j/
Requirements:
Java 1.6
Comments not found