Components

Back Next

Editing and deleting user-defined functions

Certain restrictions apply when you edit or delete a user-defined function.

Editing a user-defined function can affect the expressions and functions that use it. Consider the following guidelines when you edit a user-defined function:

If you edit a user-defined function and the updated function is valid,

Data Integration

propagates the changes to all expressions and user-defined functions that use the function.

Sometimes this can make the expressions and functions that use the user-defined function invalid. For example, you edit a function, change the number of arguments from one to two, and validate the function. Even though the updated function is valid, expressions and functions that use the user-defined function become invalid if they pass one argument to the function.

If you edit and save a user-defined function but the updated function is not valid,

Data Integration

does not propagate the changes to the expressions and user-defined functions that use it.

You cannot rename a user-defined function after you save it.

To delete a user-defined function, you must first remove it from all expressions and functions that use it. You cannot delete a user-defined function that is used in an expression or in another user-defined function.