Preface

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.

Preface

Technical documentation

» Table of Contents

» Index