Skip to main content

ISQL tutorial

FairCom Interactive SQL - quick start tutorial

FairCom_DB_Horizontal_logo.svg

Use ISQL to run SQL statements on a FairCom server:

  1. Optionally install and start up the FairCom Database Engine as needed. See Installing FairCom Products.

  2. Optionally read the Introduction to ISQL.

  3. Use ISQL to run SQL statements in any of the following ways:

    • Run the sample scripts from the included batch file to see them work.

      <faircom>\drivers\sql.cli\tutorials\cmdline\BuildTutorials.bat

      NOTE: Each script cleans up after it runs, so you can repeatedly run each one.

    • Run ISQL interactively:

      • Launch a shell in the<faircom>\tools directory.  

      • Run isql -u ADMIN -a ADMIN ctreeSQL

      • Load the sample script files into a text editor. These files are located in the<faircom>\drivers\sql.cli\tutorials directory.

      • Copy SQL statements from the sample scripts and paste them into ISQL. 

      • When copying an individual SQL statement, be sure to include the semicolon at its end. 

      • When done, type exit.

Introduction to ISQL

FairCom interactive SQL (ISQL) is a CLI that executes SQL statements on FairCom servers. You can run batch scripts from a command line shell or launch it from a shell and run SQL statements interactively. With few exceptions, you can send any SQL statement to ISQL, including CREATE, SELECT, and GRANT statements.

Tip

Data Explorer is a browser-based application that can also run SQL statements interactively.

See also

A shell is a program supplied by an operating system for running non-graphical programs and scripts. When run, the shell presents a user with a command-line prompt in which a user can type commands. Windows includes two shells: cmd and PowerShell. Linux and MacOS include bash. FairCom provides command-line interface programs that run in cmd and bash.

Abbreviation for a command-line-interface. This is the interface that operates in a shell (also known as a DOS window, console window, or a command prompt).