Replacing a Scalar User Defined Function Definition

You can replace the SQL definition, the return type, and change whether the function is recompiled each time it is executed.

  1. In the left pane of the Administration Console, expand ASE Servers > Compiled Objects > Functions > Scalar Functions.
  2. Choose one of the following:
    • Click the drop-down arrow on the scalar function for which you want to replace the definition and select Replace.
    • From Scalar Functions in the left pane, click the drop-down arrow and select New. Enter the name of the existing scalar function for which you want to replace the definition.

      When selecting an existing scalar function, the Confirm Replace dialog appears with an option to replace the object definition or cancel the replacement.

    The Replace Scalar Function wizard appears.
  3. (Optional) On the Return Type screen, enter any changes to the return type.
  4. (Optional) On the Compilation Option screen, change the recompile behavior for compiling the function.
  5. (Optional) On the SQL Editor screen, enter any changes to the SQL description.
  6. (Optional) On the Summary screen, verify the function name, database, the return type, and recompile option.