Mapping functions with the same name

You can create a mapping between two functions (or a Db2® function template and a data source function) that have the same name.

Procedure

To map two functions with the same name, issue the CREATE FUNCTION MAPPING statement.

Example: You want to map a user-defined function named MYFUN at an Informix® data source to the Db2 user-defined function named TINA.MYFUN. The Informix data source server is called INFORMIX2. The following statement maps the function:

CREATE FUNCTION MAPPING FOR TINA.MYFUN(SYSTEM.INTEGER) SERVER INFORMIX2