Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 LUW Property Editors › Support for Federation in DB2 LUW › Define DB2 LUW Function Mappings

Define DB2 LUW Function Mappings

Use the options in the DB2 for LUW Function Mapping Editor to define function to function mappings.

To define DB2 LUW Function Mappings

1. Right-click a Function Mapping in the Model Explorer and select Properties.

   The DB2 for LUW Function Mapping Editor opens.

2. Select a function mapping name and work with the following options:

   Note: Click New on the toolbar to create a function mapping. Use the Enter filter text text box to filter a large list of names to locate the one you want to work with.

   Name

   Specifies the function mapping name.

   Generate

   Specifies whether or not to generate DDL for this object during Forward Engineering.

3. On the General tab, work with the following properties:

   Function Mapping Properties:

   Type

   Specifies the function mapping type. Select Function Reference or Specific Function from the drop-down list.

   Function

   Specifies the function to associate with the function mapping. Create or select a function from the drop-down list.

   Use Infix (check box)

   Specifies whether or not to generate the data source function in infix format.

   Function Mapping Server Information:

   Server

   Specifies the server name to associate with the function mapping. Create or select a server from the drop-down list.

   Server Type

   Indicates the server type.

   Server Version

   Indicates the server version.

   Wrapper

   Specifies the wrapper to associate with the function mapping. Create or select a wrapper from the drop-down list.

4. Click the Function Mapping Options tab to specify function mapping options and their values.
5. Click the Comment tab and enter any comments you want to associate with the function mapping.
6. Click the UDP tab to work with user-defined properties for the function mapping.
7. Click the Notes tab to view history information and view or edit user notes.
8. Click Close.

   The DB2 for LUW Function Mapping Editor closes.

More Information:

Define a DB2 LUW Index Extension