ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 627

Sample DBEnvironment

Setting Up PartsDBE

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 simpliﬁes 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 <Undeﬁned Cross-Reference> 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 ﬁrst 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.)