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 SQLDBE
Displays all the DBEnvironments associated with a specific TurboIMAGE/XL database.
- DISPLAY MAP
Displays the current data type mapping information for 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 commands 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
Two examples using the DISPLAY commands are shown below and on the next page.
Example 1: Displaying Database Information |
 |
To see all the TurboIMAGE/XL databases and mapped tables currently associated with
PartsDBE, use the DISPLAY TURBODB command.
:RUN IMAGESQL.PUB.SYS
>>DISPLAY TURBODB TABLES FOR PARTSDBE.SERED.ATC
DBEnvironment : PARTSDBE.SERED.ATC
TURBOIMAGE/XL DATABASE OWNER MAPPED TABLE
---------------------- ----- ------------
SALES.SERED.ATC SALES DATE_MASTER
CUSTOMER
PRODUCT
VENDOR
INVENTORY
SALES
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
SQL tables. In the following example, information about
the mapped table INVENTORY is displayed.
>>DISPLAY MAP INVENTORY
TurboIMAGE/XL DB : SALES.SERED.ATC
DBEnvironment : PARTSDBE.SERED.ATC
Owner Name : SALES
MAPPED(SOURCE) SOURCE MAPPED SOURCE MAPPED
TABLE FIELD COLUMN TYPE TYPE NOTES
------------ ---------------- ------------------ ------- ----------- -----
INVENTORY (INVENTORY)
PRODUCT# PRODUCT# U8 CHAR(8)
ON-HAND-QTY ON_HAND_QTY J2 INTEGER
VENDOR VENDOR X16 CHAR(16)
OTHER-VENDORS OTHER-VENDORS_1 X16 CHAR(16) S
OTHER-VENDORS OTHER-VENDORS_2 X16 CHAR(16) S
OTHER-VENDORS OTHER-VENDORS_3 X16 CHAR(16) S
UNIT-COST UNIT_COST P8 DECIMAL(7,0)
LAST-SHIP-DATE LAST_SHIP_DATE X6 CHAR(6)
LOCATION-BIN LOCATION_BIN Z2 DECIMAL(2,0)
PART-INFO PART_INFO X60 CHAR(60)
NOTES:
S: Source field has been split
|
Here, the S in the NOTES section indicates that the compound data item,
OTHER_VENDORS, has been mapped and split into three mapped columns.
