HP 3000 Manuals HP 3000 Manuals
Displaying IMAGE/SQL Utility Information
This task describes how to display IMAGE/SQL information using several
IMAGE/SQL utility commands.
These commands include:
DISPLAY OPTIONS Displays the options in effect for your current
IMAGE/SQL utility session.
DISPLAY TURBODB Displays all the TurboIMAGE/XL databases associated
with a specific DBEnvironment.
DISPLAY MAP Displays the current data type mapping information
for a specific TurboIMAGE/XL database.
DISPLAY SQLDBE Displays all the DBEnvironments associated with a
specific TurboIMAGE/XL database.
DISPLAY USER Displays the current information about users in a
specific TurboIMAGE/XL database.
HELP Provides the syntax of IMAGE/SQL utility commands.
Getting Ready
* The DISPLAY command provide two options: Either issue SET
commands before displaying information, or specify a particular
TurboIMAGE/XL database or DBEnvironment as part of the DISPLAY
command.
* For DISPLAY SQLDBE and DISPLAY TURBODB to display useful
information, at least one database should be attached.
* For DISPLAY MAP AND DISPLAY USER to display useful information, a
database should be attached.
Performing the Task
Examples using the DISPLAY command are shown on the following pages.
Example 1: Displaying Database Information
To see all the TurboIMAGE/XL databases and mapped tables currently
associated with MusicDBE, use the DISPLAY TURBODB command.
_____________________________________________________________
| |
| :RUN IMAGESQL.PUB.SYS |
| >>DISPLAY TURBODB TABLES FOR MUSICDBE.PUB.TURBONM |
| |
| DBEnvironment : MUSICDBE.PUB.TURBONM |
| |
| TURBOIMAGE/XL DATABASE OWNER MAPPED TABLE|
| ---------------------- ----- ------------|
| |
| MUSIC.PUB.TURBONM MUSIC ALBUMS |
| COMPOSERS |
| SELECTIONS_A|
| SELECTIONS |
| LOG |
| |
| Total Databases : 1 |
| >> |
_____________________________________________________________
Any databases attached to the DBEnvironment and their associated mapped
tables are displayed.
Example 2: Displaying Database Mapping Information
The DISPLAY MAP command shows how TurboIMAGE/XL data sets are mapped to
ALLBASE/SQL tables. In the following example, information about the
mapped table ALBUMS is displayed.
______________________________________________________________________________________
| |
| >>DISPLAY MAP ALBUMS |
| |
| ATTACHED BASES : MUSIC.PUB.TURBONM |
| DBEnvironment : MUSICDBE.PUB.TURBONM |
| Owner Name : MUSIC |
| |
| MAPPED(SOURCE) SOURCE MAPPED SOURCE MAPPED |
| TABLE FIELD COLUMN TYPE TYPE NOTES|
| ------------ ---------------- -------------------- ------- -------------- -----|
| |
| ALBUMS (ALBUMS) |
| ALBUMCODE ALBUMCODE I2 INTEGER |
| ALBUMTITLE ALBUMTITLE X40 CHAR(40) |
| MEDIUM MEDIUM X2 CHAR(2) |
| ALBUMCOST ALBUMCOST P8 DECIMAL(7,0) |
| RECORDINGCO RECORDINGCO X10 CHAR(10) |
| DATERECORDED DATERECORDED X16 CHAR(16) |
| MFGCODE MFGCODE X40 CHAR(40) |
| COMMENT COMMENT X80 CHAR(80) |
______________________________________________________________________________________
Example 3: Displaying DBEnvironment Information
To see the ALLBASE/SQL DBEnvironment currently associated with MusicDBE,
use the DISPLAY SQLDBE command.
___________________________________________
| |
| >>DISPLAY SQLDBE |
| |
| ATTACHED BASES : MUSIC.PUB.TURBONM|
| |
| DBENVIRONMENT |
| ------------- |
| MUSICDBE.PUB.TURBONM |
___________________________________________
Example 4: Displaying User Information
To see the current user information associated with MusicDBE, use the
DISPLAY USER command.
________________________________________________________________
| |
| >>DISPLAY USER |
| |
| ATTACHED BASES : MUSIC.PUB.TURBONM |
| DBEnvironment : MUSICDBE.PUB.TURBONM |
| |
| USER LOGON DBOPEN MODE USER PASSWORD USER CLASS|
| ---------- ----------- ------------- ----------|
| |
| MGR@TURBONM 5 ; 64 |
________________________________________________________________