HP 3000 Manuals

Up and Running with ALLBASE/SQL

Chapter 3  Setting Up a Database with ISQL 

This chapter is a tutorial on setting up your own database using ISQL,
the interactive component of ALLBASE/SQL. The tutorial takes you through
the steps you need to follow in creating any ALLBASE/SQL database, large
or small.

Here are the steps:

   *   Running ISQL.
   *   Creating a DBEnvironment.
   *   Creating DBEFileSets.
   *   Creating DBEFiles for table and index data.
   *   Adding DBEFiles to DBEFileSets.
   *   Creating tables.
   *   Entering data into tables.
   *   Performing queries.
   *   Creating views.
   *   Granting authorities.
   *   Creating an index.
   *   Examining the system catalog.

The example chosen to illustrate these steps is a database of information
about record albums.  This database uses the tables described in chapter
2, "Looking at Data." Follow the steps yourself on a system in an empty
group (MPE XL) or directory (HP-UX).

MPE/iX 5.0 Documentation