FairCom Corporation 1-1
Chapter 1
Introduction
1.1 OVERVIEW
Interactive SQL (often referred to throughout this manual as ISQL) is a utility supplied with c-
treeSQL that lets you issue SQL statements directly from a terminal and see results displayed
at the terminal. 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 state-
ments
With few exceptions, you can issue any SQL statement in interactive SQL that can be embed-
ded in a program, including CREATE, SELECT, and GRANT statements. Interactive SQL
includes an online help facility with syntax and descriptions of the supported statements.