Dropping a function mapping

When you no longer require a function mapping that you created, you can delete the function mapping by running the DROP statement.

Before you begin

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

About this task

If you drop a function mapping that you created to override a default function mapping, the default function mapping will be used.

The function mappings are listed in the SYSCAT.FUNCMAPPINGS catalog view.

Procedure

To drop a function mapping that you created, use the DROP statement:

Example: Drop a function mapping called BONUS_CALC
DROP FUNCTION MAPPING BONUS_CALC