Use the DB2 for LUW Type Mapping Editor to define properties for data type mappings in a DB2 LUW physical model.
To define DB2 LUW type mappings
The DB2 for LUW Type Mapping Editor opens.
Note: Click New on the toolbar to create a type mapping. Use the Enter filter text text box to filter a large list of names to locate the one you want to work with.
Specifies the name of the type mapping.
Specifies the data type that is being mapped to a federated database.
Specifies whether the character type data is for binary.
Specifies the data type that is being mapped from a federated database.
Specifies the mapping direction. Select a direction type (Remote To Local or Local To Remote) from the drop-down list.
Specifies whether or not to generate DDL for this object during Forward Engineering.
Specifies the server name to associate with the type mapping. Select a server from the drop-down list.
Identifies the type of server for the type mapping.
Identifies the version of the server for the type mapping. See IBM DB2 reference documentation for acceptable parameters (for example, version, release, and so on.)
Specifies the name of the wrapper that the federated server uses to interact with the defined server type and server version. Select a wrapper from the drop-down list.
You can specify the following parameters for precision and scale for remote mapping:
Specifies whether the data-source-data-type is for bit data.
Specifies the minimum value for precision for a remote data type.
Specifies the maximum value for precision for a remote data type.
Specifies the minimum value for scale for a remote data type.
Specifies the maximum value for scale for a remote data type.
Specifies an arithmetical expression to filter precision and scale. Select from the drop-down list.
The DB2 for LUW Type Mapping Editor closes.
Copyright © 2013 CA.
All rights reserved.
|
|