HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

Chapter 5  Database Creation and Security 

Once the DBEnvironment is configured and storage is allocated, you can
begin creating the tables, views, indexes, and other objects that
comprise databases.  The examples in this chapter show the statements for
creating specific tables, views, and authorities within the sample
DBEnvironment PartsDBE. A complete set of statements for creating all the
tables, views, and authorities in PartsDBE is found in the "Sample
DBEnvironment" appendix of the ALLBASE/SQL Reference Manual.

Tasks presented in this chapter are:

   *   Creating tables
   *   Creating views
   *   Creating hash structures
   *   Creating indexes
   *   Creating procedures and rules
   *   Creating the database security scheme
   *   Creating a database schema
   *   Loading tables

MPE/iX 5.5 Documentation