You can use the workbench to create, test, and deploy several
types of user-defined functions (UDFs). UDF development is not supported
for every database server.
A UDF is an extension or addition to the existing built-in functions
of SQL, such as those provided in the SYSFUN schema in DB2®. User-defined functions and stored procedures
are sometimes referred to collectively as routines.
Creating user-defined functions (UDFs)
You can create a user-defined function from a data development
project in the Data Project Explorer, or from a connection in the
Data Source Explorer.
Versioning DB2 for z/OS non-inline scalar functions
You can use the workbench to create a new version of a
non-inline scalar function for DB2 for z/OS®. You can create a new version
from a data development project, or you can create a new version from
the Data Source Explorer. This feature is supported only for DB2 z/OS 10.0
or higher.