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.

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.