Creating function mappings

Use the CREATE FUNCTION MAPPING statement to specify alternative function mappings that override the default function mappings.

When you create alternative function mappings, the entries appear in the SYSCAT.FUNCMAPPINGS catalog view.

You can also use the CREATE FUNCTION MAPPING statement to specify function mapping options. When you specify function mapping options, the information appears in the SYSCAT.FUNCMAPOPTIONS catalog view.

With the CREATE FUNCTION MAPPING statement, you can:
  • Create a function mapping for all data sources of a specific type. For example, all Informix® data sources.
  • Create a function mapping for all data sources of a specific type and version. For example, all Informix 9 data sources.
  • Create a function mapping for a specific server.
  • Provide function mapping statistical information to the optimizer
  • Disable a default function mapping or a function mapping that you defined.

You can issue the CREATE FUNCTION MAPPING statement in the command line processor. You can also embed the CREATE FUNCTION MAPPING statement in an application program.