Run queries and SQL commands.
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/ View larger image
Operating systems:
Windows 7, Windows 8, Windows Vista, Windows XP, Windows 2003, Windows Me, Windows 98, Windows 2000, Windows NT, Windows Server 2008
Additional requirements:
Java 1.6
Date:
12.07.2013
Похожие программы
