DISPLAY MAP

Displays the current data type mapping information for a specified TurboIMAGE/XL database.

Syntax

DI[SPLAY] MAP [FOR TurboDB [,MAINT=TurboMaintWord] ] [MappedTable [.MappedCol]] [,...]

Parameters

TurboDB: is the name of the TurboIMAGE/XL database whose data type mapping information you want to display. This name can be a fully qualified group and account name. If this parameter is omitted, the name of the database defined in the most recent SET TURBODB command is used.
TurboMaintWord: is the maintenance word for the TurboIMAGE/XL database. This parameter can be omitted if you are the database creator (DBC).
MappedTable: is the name of a mapped table whose data type mapping information you want to display. If this parameter is omitted, information about all mapped tables is displayed.
MappedCol: is the name of a specific mapped column in the table whose data type mapping information you want to display. If this parameter is omitted, information about all columns in the table is displayed.

Prerequisites

SET SQLDBE issued.
SET TURBODB issued or TurboIMAGE/XL database (and maintenance word, if not DBC) specified as part of the command.
DBA authority.
Database attached.

Description

Use the DISPLAY MAP command to display name and data type mapping information for a TurboIMAGE/XL database attached to an SQL DBEnvironment. Information is displayed about the DBEnvironment named in the most recent SET SQLDBE command.

If the database is attached to more than one DBEnvironment, issue additional SET SQLDBE commands to see the data type mapping for each DBEnvironment to which it is attached.

In the display generated by this command:

An I in the NOTES section next to a particular mapping indicates that the default data type mapping is inexact or imprecise.
An S in the NOTES section next to a particular mapping indicates that the mapped column has been split. This occurs by default when the source field is a compound data item. The SPLIT command may also have been used to explicitly split a mapped column into smaller mapped columns. In this case, a U also appears in the NOTES section.
A U in the NOTES section next to a particular mapping indicates that the default data type mapping has been updated with the UPDATE TYPE command.

Refer to the SPLIT and UPDATE TYPE commands for information about how to select alternative data type mapping.

Example

In the following example, mapping information for the mapped table INVENTORY is displayed. The compound source field OTHER-VENDORS has been split into three mapped columns: OTHER_VENDORS_1, OTHER_VENDORS_2, and OTHER_VENDORS_3. Note that the source data set name, in this case INVENTORY, is shown in parentheses after the name of the mapped table.

 >>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)

              STOCK#           STOCK#             U8      CHAR(8)

              ONHANDQTY        ONHANDQTY          J2      INTEGER

              SUPPLIER         SUPPLIER           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)

              LASTSHIPDATE     LASTSHIPDATE       X6      CHAR(6)

              BINNUM           BINNUM             Z2      DECIMAL(2,0)

              PART-INFO        PART_INFO          X60     CHAR(60)



 NOTES:

   S: Source field has been split

 >>

DISPLAY MAP

Technical documentation

» Table of Contents

» Glossary

» Index

Syntax

Parameters

Prerequisites

Description

Example