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 “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:
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.

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.

Setting Up a Database with ISQL

Technical documentation

» Table of Contents

» Glossary

» Index

Running ISQL

Creating a DBEnvironment