isql

The isql utility is a command-line SQL client that works on SQL Server through SQL commands. Using the proper queries it’s possible to manage all database items, like tables, users and triggers.

Usage:

isql [-s<script>] [-u username] [-a passwd] port@ipaddress:databasename

Where:

•	script is a text file encoded with UTF-8 that contains SQL commands to execute. This feature is useful if you need to launch one or more SQL commands without user interaction.

•	username is the login user, e.g. ‘admin’

•	passwd is the login password, e.g. ‘ADMIN’

•	port is the port on which SQL Server is listening, e.g. ‘6597’

•	ipaddress is the address on which SQL Server is listening, e.g. ‘localhost’

•	databasename is the name of the SQL Server database, e.g. ‘ctreeSQL’

If the login is successful the following prompt will appear and you will be able to input SQL commands:

FairCom/isql.exe Version 11.2.0.10214(Build-160621)                              FairCom Corporation (C) 1992-2016.                 Dharma Systems Pvt Ltd-Dharma Systems Inc (C) 1992-2016.   ISQL>

Consult the SQL Reference Manual (sqlref.pdf) installed with the product for information about the supported SQL syntax.