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
|
