HP 3000 Manuals

ALLBASE/SQL Reference Manual

Appendix C  Sample DBEnvironment 

The DBEnvironment used in examples throughout the ALLBASE/SQL manual set
is called PartsDBE. Your installation package includes the necessary
files to create a working version of this DBEnvironment so that users can
try the examples while learning about the features of ALLBASE/SQL. Also
included is a set of sample applications that access PurchDB, the main
database in PartsDBE.

This appendix presents the steps for setting up the sample DBEnvironment
and then displays some important files and tables related to PartsDBE. It
contains the following sections:

   *   Setting Up PartsDBE
   *   ISQL command files for creating and loading PartsDBE
   *   Tables in the ManufDB, PurchDB, and RecDB Databases
   *   Sample Program Files

Before you can use PartsDBE, you must install the sample database files,
then run a setup script to create and load PartsDBE. Optionally, you can
preprocess and compile the sample application programs. 
Before starting, be sure to enable the UDCs supplied with ALLBASE/SQL by
issuing the following MPE/IX command:

     SETCATALOG HPSQLUDC.PUB.SYS

MPE/iX 5.5 Documentation