HP 3000 Manuals HP 3000 Manuals
Setting Up a Database with ISQL
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:
* Running ISQL
* Creating a DBEnvironment
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:
_____________________________________
| |
| :RUN ISQL.PUB.SYS Return |
_____________________________________
You will then see the ISQL banner as shown in Figure 5-2 (some
details may be slightly different on your system):
________________________________________________________________________________
| |
| |
| 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=> |
| |
________________________________________________________________________________
Figure 5-2. ISQL Banner
[REV BEG]
* 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:
_____________________________________
| |
| isql=>EXIT; Return |
_____________________________________
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.[REV END]
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.