HP 3000 Manuals HP 3000 Manuals
Setting Up PartsDBE
Before beginning, change into the group and account where you want to
create PartsDBE. Use an empty group if possible. Then choose one of the
following two methods for setting up PartsDBE:
* Using SQLSetup
* Using CREASQL
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 command prompt,
issue the following command:
: SQLSETUP.SAMPLEDB.SYS Return
A menu like the one in Figure C-1 appears on your screen.
________________________________________________________________________________
| |
| |
| 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=> |
| |
________________________________________________________________________________
Figure C-1. SQLSetup Menu
From this menu, you select an option to create a copy of PartsDBE in your
group and account. 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 group, 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 CREASQL
The following is an alternate method for setting up PartsDBE. Use the
command file CREASQL to stream a job that sets up PartsDBE. First, copy
the CREASQL stream file to your group and account with the following
command:
: FCOPY FROM=CREASQL.SAMPLEDB.SYS;TO=CREASQL;NEW Return
Using an editor, modify CREASQL to include your password(s), user name,
account name, and group name. Lines that need to be modified are shown
in inverse display. Keep the edited file, then type the following
command to create and load PartsDBE and copy the sample programs into
your group and account:
: STREAM CREASQL Return
You will see messages showing the progress of the setup script.