HP 3000 Manuals HP 3000 Manuals
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.
_________________________________________________________________________________
|[REV BEG] |
| |
| >>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 |
| >> |
_________________________________________________________________________________
[REV END]