HP 3000 Manuals HP 3000 Manuals
Task 10: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 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.