Creating function mappings for nicknames on SSPD servers in Data Virtualization

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 Prestodata sources.
• Create a function mapping for a specific server.

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.