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.

Task 10: Displaying IMAGE/SQL Utility Information

Technical documentation

» Table of Contents

» Glossary

» Index

Example 1: Displaying Database Information

Example 2: Displaying Database Mapping Information