ISQL tutorial
FairCom Interactive SQL - quick start tutorial
Use ISQL to run SQL statements on a FairCom server:
Optionally install and start up the FairCom Database Engine as needed. See Installing FairCom Products.
Optionally read the Introduction to ISQL.
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.