This manual describes ISQL (Interactive Structured Query Language) and
how to use it on HP 9000 computers running under the HP-UX
operating system. SQL is the language you use to define and maintain data in an
ALLBASE/SQL DBEnvironment.
ALLBASE/SQL is Hewlett-Packard's proprietary
relational database management system.
Most of the examples in this manual are based on the tables, views, and
other objects in the sample database environment, PartsDBE,
which accompanies ALLBASE/SQL. Refer to appendix C of the
ALLBASE/SQL Reference Manual for a full description of the
sample DBEnvironment. This appendix also contains information on
installing and setting up a copy of PartsDBE for practice use.
This manual is for database administrators, application programmers, and
any other users who want to execute SQL commands interactively. It
presumes that the reader has a grasp of basic relational database
concepts and an introductory understanding of ALLBASE/SQL.
This manual contains the following chapters:
Chapter 1, "Introduction," presents the components of ISQL.
Chapter 2, "Getting Started with ISQL," describes how to use ISQL.
Chapter 3, "Using ISQL for Database Tasks,"
shows how to perform data manipulation and load/unload operations
using ISQL.
Chapter 4, "ISQL Commands," contains an alphabetical reference of all
the ISQL commands.
Appendix A, "SQL Syntax Summary," contains an alphabetical summary of all
the SQL commands and other elements of syntax.
Appendix B, "ISQL Syntax Summary," contains an alphabetical summary of all
the ISQL commands.
