Before beginning, change into the
group and account
where you want to create PartsDBE. Use an empty
group if ossible. Then choose one of the following
two methods for setting up PartsDBE:
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 “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
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:
You will see messages showing the progress of the setup script.
