User Defined Functions
There are many rules for handling User Defined Functions (UDFs). You can see them in the IBM Db2 for z/OS SQL Reference.
The User Defined Function screen (see the following figure) displays when option 8 is selected on the Object Selection Menu.
User Defined Function Screen
Option
Specify the letter of the required option:
C | Create a function. |
A | Alter a function. |
D | Drop a function. |
M | Model a function and create a new function. |
Specify UDF Information (* or pattern for list) Area
Schema Name
The name of the schema in which the new UDF should be created. This field is required. This field defaults to the SQL authorization ID if no schema is entered. Must not begin with ‘SYS’ unless it is ‘SYSADMIN’ or ‘SYSPROC’.
You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window, from which you can select a specific object.
Function Name
Name of the function as it is called by SQL statements. You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window, from which you can select a specific object.
Specific Name
Specific name of the UDF. If you do not provide a name, Db2 generates a unique name in the form SQLxxxxxxxxxxxx. You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window, from which you can select a specific object.
Related topics