Routine Editor - User-Defined Function - Options page

Use the Options page to view optional settings for the user-defined function.
Specific name
Shows the specific name for the user-defined function, a unique name that distinguishes multiple user-defined functions with the same name and different parameters. If you do not specify this name, the database generates it the first time you build the procedure. You can use the specific name to drop or comment on a user-defined function. You can not use the specific name to invoke the user-defined function.
Language
Shows the language of that the user-defined function is written in.
Package
Shows the package for the SQL user-defined function.
Contains SQL
Specifies that the user-defined function contains SQL statements and does not read nor modify SQL data.
Deterministic
Shows whether the user-defined function returns the same result from successive calls with identical input parameters. When this check box is not selected, the user-defined function might not return the same result from successive calls with identical input parameters.
External action
When checked, specifies that the function takes some action that changes the state of an object that is not managed by the database manager. External action must be explicitly or implicitly specified if the body of the function calls another function that has an external action.

Feedback