HPlogo ALLBASE/SQL Reference Manual > Appendix C Sample DBEnvironment

Setting Up PartsDBE

MPE documents

Complete PDF
Table of Contents
Index

E0300 Edition 9 ♥
E0399 Edition 8
E0897 Edition 7

Before beginning, change into the directory where you want to create PartsDBE. Use an empty directory if possible. Then choose one of the following two methods for setting up PartsDBE:

  • Using SQLSetup

  • Using Setup

SQLSetup is a sample database setup tool which simplifies the process of installing PartsDBE in your work space. Setup is a lower-level script called by SQLSetup.

Using SQLSetup

Run SQLSetup by issuing the proper command. From the C shell, issue the following command: 

   $ /usr/lib/allbase/hpsql/sqlsetup Return
From the K shell or Bourne shell, issue the following command: 

   $ csh /usr/lib/allbase/hpsql/sqlsetup Return
A menu like the one in Figure C-1 "SQLSetup Menu" appears on your screen.

Figure C-1 SQLSetup Menu 

       Options for Setting Up ALLBASE/SQL Sample DBEnvironments

   ===============================================================

   Choose one:

   1. Create PartsDBE without sample programs
   2. Create PartsDBE, copy, preprocess and compile sample programs
   3. Copy, preprocess and compile sample programs only
   4. Generate a schema for PartsDBE
   5. Display schema for PartsDBE
   6. Purge PartsDBE and sample programs
   7. Help
   0. Exit

   ===============================================================

   Enter your choice=>
From this menu, you select an option to create a copy of PartsDBE in your directory. Before choosing an option, examine each line on the menu. The first option simply creates a copy of PartsDBE. The second option, in addition to creating PartsDBE, copies a set of application programs into the current directory, then preprocesses and compiles them. (This is time-consuming.)

Option 3 creates just the sample program set. Option 4 creates a database schema by calling SQLGEN. Option 5 displays the schema once it has been created. Option 6 lets you purge the sample DBEnvironment and programs.

Choose the Help option to see more information about SQLSetup, or choose 0 to exit.

Creating PartsDBE

To create PartsDBE, choose option 1 from the SQLSetup menu. This option runs a set of ISQL command files that create the DBEnvironment, define all its tables, views, indexes and security structure, and then load it with data.

As the system creates PartsDBE, you see several messages displayed. At the end of the creation process, you see the following message: 

   Creation and Loading of PartsDBE is now complete!
When you return to the menu, choose 0 to exit.

Using Setup

The following is an alternate method for setting up PartsDBE.

Use the following command: 

   $ /usr/lib/allbase/hpsql/setup 2 Return
You will see a display of messages showing the progress of the setup script. For more information about setup, read the comments at the beginning of the file itself.



Installing the Files for PartsDBE

Listings of ISQL Command Files