ALLBASE/SQL Reference Manual (36216-90216)

628 AppendixC
Sample DBEnvironment
Setting Up PartsDBE
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.