HPlogo Up and Running with ALLBASE/SQL: HP 3000 and HP 9000 Computer Systems

Chapter 3 Setting Up a Database with ISQL

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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/iX) or directory (HP-UX).

Feedback to webmaster