c-treeACE SQL Interactive SQL
The c-treeACE SQL Interactive SQL utility (ISQL) provides an industry standard "command processing" interface" to the c-treeACE SQL Database Engine.
FairCom offers two separate implementations of Interactive SQL:
- A command-line version (isql.exe or isql). This utility is designed as a command-line tool and can be placed in job streams.
- A GUI tool version within the Windows program c-treeACE SQL Explorer.
Either implementation allows you to issue SQL statements directly from a command prompt for immediate displayed results. You can use Interactive SQL to:
- Learn how SQL statements work;
- Test and prototype SQL statements to be embedded in programs;
- Modify an existing database with data definition statements;
- Perform ad-hoc queries and generate formatted reports with special ISQL formatting statements;
- Run existing SQL scripts.
With few exceptions, you can issue any SQL statement in ISQL that can be embedded in a program, including CREATE, SELECT, and GRANT statements. Interactive SQL includes an online help facility with syntax and descriptions of the supported statements.
View the c-treeACE SQL ISQL Tools and Reference Guide for a complete introduction.
|
