Function mapping options for federated systems

The federated server provides default mappings between Db2® functions and data source functions. For most data sources, the default function mappings are in the wrappers. To use a data source function that the federated server does not recognize or to change the default mapping, you create a function mapping.

When you create a function mapping, you specify the name of the data source function and must enable the mapped function. Then when you use the mapped function, the query optimizer compares the cost of running the function at the data source with the cost of running the function at the federated server.

Table 1. Options for function mappings
Name Description
DISABLE Enable or disable a default function mapping. Valid values are Y and N. The default is N.
REMOTE_NAME The name of the data source function. The default is the local name.