This manual describes ISQL (Interactive Structured Query Language) and how to use it on HP 3000 computers running under the MPE/iX
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.
MPE/iX, Multiprogramming Executive with Integrated POSIX, is the latest
in a series of forward-compatible operating systems for the HP 3000
line of computers.
In HP documentation and in talking with HP 3000 users, you will
encounter references to MPE XL, the direct predecessor of MPE/iX.
MPE/iX is a superset of MPE XL. All programs written for MPE XL
will run without change under MPE/iX. You can continue to use MPE XL
system documentation, although it may not refer to features added to
the operating system to support POSIX (for example, hierarchical
directories).
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.
