Federation: Creating a function mapping for all data source objects on a specific server

You can create a mapping to a function that is used by all data sources objects on a specific remote server.

Before you begin

The privileges held by the authorization ID of the statement must have SYSADM or DBADM authority.

Restrictions

You cannot override the existing function mappings or create new mappings for nonrelational data sources.

Procedure

To create a function mapping for all data source objects on a specific server, use the CREATE FUNCTION MAPPING statement.

Example: Map a function template called BONUS to a user-defined function called BONUS

You only want the mapping to apply to an Oracle data source server called ORA_SALES. Because the function names are the same, you do not need to specify the REMOTE_NAME function mapping option.

CREATE FUNCTION MAPPING BONUS_CALC FOR BONUS() 
 SERVER ORA_SALES