 |
» |
|
|
|
This task shows how to set up a new database environment using
the IMAGE/SQL utility and ISQL, the interactive component of Hewlett-Packard's
SQL products.
The steps to create the database environment are:
The example chosen to illustrate these steps
is a database of information about record albums.
This database environment will be used again in Chapter 6, "Practicing with
IMAGE/SQL Using MusicDBE." Running ISQL |  |
Before you can create a new DBEnvironment, you must run ISQL.
Performing the Task
Run ISQL by entering the following at your operating system prompt:
You will then see the ISQL banner as shown
in Figure 5-2 “ISQL Banner” (some details may be slightly different on your system):
Figure 5-2 ISQL Banner
IIIIIIII SSSSSSSS QQQQQQQ LL
II SS QQ QQ LL
II SS QQ QQ LL
II SSSSSS QQ QQ LL
II SS QQ Q QQ LL
II SS QQ QQ LL
IIIIIIII SSSSSSS QQQQQQ QQ LLLLLLLLL
MON, FEB 8, 1993, 10:51 AM
HP36216-02A.F0.29 Interactive SQL/3000 ALLBASE/SQL
(C)COPYRIGHT HEWLETT-PACKARD CO. 1982,1983,1984,1985,1986,1987,1988,
1989,1990,1991,1992. ALL RIGHTS RESERVED.
isql=>
|
Use a semicolon and press Return to terminate
a command in ISQL. If you forget to use the semicolon, a continuation prompt appears:
Type a semicolon and press Return, or
to terminate, type //.
Leave ISQL by typing the following:
If ISQL asks whether or not you
want to commit work, you must reply either Y or N and press Return.
Entering Y makes the work you have done permanent.
Creating a DBEnvironment |  |
To create a new DBEnvironment, use the START DBE NEW
command at the ISQL prompt. This is explained in the next task.
Task Reference
For complete information about startup parameters, refer to the
"DBEnvironment Configuration and Security" chapter of the
ALLBASE/SQL Database Administration Guide.
For more information about log files,
refer to the "Backup and Recovery" chapter in the
ALLBASE/SQL Database Administration Guide.
For more information on configuring a DBEnvironment, refer to the
entry for START DBE NEW in the "SQL Statements" chapter
of the ALLBASE/SQL Reference Manual. This entry describes all the default configuration values used in creating MUSICDBE.
|